Login | Register   
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
Expertise: Beginner
Mar 29, 2005

Obtain Different Portions of a SQL Datetime Field

SQL has the habit of displaying date fields as: yyyy-mm-dd 00:00:00.000. But sometimes, you need to display just the Date or just the Time from a date field. Here are some of the more common, alternate formats:

CONVERT(CHAR,CURRENT_TIMESTAMP,20)	--[ yyyy-mm-dd hh:mi:ss(24h) ]
CONVERT(CHAR(10),CURRENT_TIMESTAMP,20)	--[ yyyy-mm-dd ]
CONVERT(CHAR(10),CURRENT_TIMESTAMP,110)	--[ mm-dd-yyyy ]
CONVERT(CHAR(8),CURRENT_TIMESTAMP,8)	--[ hh:mm:ss ]
CONVERT(CHAR(5),CURRENT_TIMESTAMP,8)	--[ hh:mm ]
This example uses the System date (CURRENT_TIMESTAMP), but any SQL date field will do.

Hani Greiss
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap