convert int to timestamp

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  October 8, 2007 at 10:11 am

  #182629

  Hi all,

  I have column with int data type and the it contains data such as

  47154. I think it is in Seconds and i need to convert it to time stamp such as

  00:00:00 hh:min:sec!!

  how can it do that i am blank on this!!

  Thanks

• Joel Ewald

  SSCertifiable

  Points: 6120

  More actions

  October 8, 2007 at 10:27 am

  #740088

  select dateadd(ss, 47154, 0 )

  ss being seconds

  47154 being you time offset.

  0 being a date of some sort (0 = 01-01-1900)

  search bol for dateadd / convert and you should be able to pull what you need.