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
May 30, 1997

Date format

Question:
My application (RIS) converts a date in an integer to store it in a Database. Integer = x seconds after 1.1.1970 (for ex., 709444800). I want to make a SQL query that will reconvert this INT into a date format.

Answer:
The only way to do this as a SELECT statement is to embed the math in the SELECT clause and then CAST or otherwise convert the result to date format.

This would be quite unsightly as a query and wouldn't lend itself well to use in multiple places. If your database supports user-defined functions, that would be the best solution. Alternatively, a stored procedure or trigger could do the conversion for you.

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