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

  • Question

  • 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

  • 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