
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