How to decode Timestamp in SQL

• Feebie

  Right there with Babe

  Points: 785

  More actions

  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.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 8, 2009 at 3:01 pm

  #1021942

  Multiple post, please post replies here.

• Lowell

  SSC Guru

  Points: 323527

  More actions

  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!

• Feebie

  Right there with Babe

  Points: 785

  More actions

  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?