How to decode Timestamp in SQL

• Feebie

  Right there with Babe

  Points: 785

  More actions

  July 8, 2009 at 3:00 pm

  #103781

  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:02 pm

  #1021945

  Multiple post, please post replies here.