Date Conversion from Seconds to Normal

Question:
Is there some way to write a function that converts a date that is in seconds since December 31, 1969, into a normal date format?

Like this: date from (900,973,200) in seconds to (YYYY,MM,DD) or any normal format.

Answer:
The dateadd funtion takes three arguments: the date part, a number, and a date. It then adds the number to the date and returns a datetime as a result.

In your case, to specify that you are adding seconds you would use ss for the datepart. So:

select dateadd (ss,900973200,'December 31,1969')

returns

1998-07-19 22:20:00.000

You can encapsulate this code in a stored procedure if you’d like.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: