devxlogo

Obtain Different Portions of a SQL Datetime Field

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.

See also  How IoT Tech Will Transform Logistics
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist