locked
Is there a way to reset the value of timestamp? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I would like to reset the value of timestamp value which normally shows an out of date and meaningless value.  If this canbe reset to show current datetime it can be of some help.  Of course we may use getdate() function but simply i would like to know if there is a way to reset timestamp value like that of identity value.

     

    Tuesday, May 23, 2006 8:32 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    The timestamp doesnt show a date at all, it is just used for row versioning mechanism. DO you mean a datetime column rather than at timestamp ? The understanding of a timestamp is different from other systems.

    HTH, Jens Suessmeyer.


    ---
    http://www.sqlserver2005.de

    ---
     
    Tuesday, May 23, 2006 9:59 AM