Post reply

How to decode Timestamp in SQL

  • July 8, 2009 at 2:58 pm

    #208031

    Hi,

    i need to help to decode the timestamp values which are there on my tables.

    For example i have a timestamp value like '0x00000000085EBC62'.

    I would like to see the value in date and time format.

    Please let me know.

  • July 8, 2009 at 3:01 pm

    #1021942

    Multiple post, please post replies here.

  • July 8, 2009 at 3:01 pm

    #1021944

    timestamp is a misnomer; the proper datatype is actually rowversion;

    it is NOT related to time in any way, it is just a unique number which is created/updated automaticall when an update occurs.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 9, 2009 at 7:43 am

    #1022360

    So, Could that help me to keep track of the recent updates on the table row updates?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply