Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Aug 29, 2000

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.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date