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 2, 1999

SQL fucntion calls

Question:
Does SQL have a function to get only the time--rather than getDate()--which gets the date and time, or a function to get the Unix time() time. (the one that give the seconds since 1970).

Answer:
If you can handle the time as a character string, the convert function can be used to return just the time. So convert(char,date_field_name,108) will return only the hh:mm:ss. Check out the formats supported by convert in the reference. Additionally, you can use the datepart function to return any part of the date--be it the hour, minute, or second--as an integer. However, to get all three, you would have to call the function three times.

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