devxlogo

Date Conversion from Seconds to Normal

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.

See also  How HealthStream Learning Center Supports Healthcare Education and Compliance
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist