Date Conversion from Seconds to Normal

Date Conversion from Seconds to Normal

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.

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')


1998-07-19 22:20:00.000

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

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular