SQL: How to get Date from DateTime?

1. Use the CAST function

The CAST function is used in SQL to convert from one data type to another.

The syntax of CAST is:

CAST(expression AS data_type)

If you want to convert a DateTime value to a Date type, you would use:

SELECT CAST(datetime_column AS DATE) FROM table_name;

2. Use the CONVERT function

CONVERT is a function in SQL that converts a value from one data type to another. In addition to the data type conversion, CONVERT also lets you specific formatting style during the conversion process.

The syntax for using CONVERT is:

CONVERT(data_type, expression, [style])

For example, to convert a DateTime value to a Date type, you would use:

SELECT CONVERT(DATE, datetime_column) FROM table_name;

And to convert a datetime column to a formatted date string, such as yyyy-mm-dd, you would use:

SELECT CONVERT(VARCHAR, datetime_column, 23) FROM table_name;

In this example, the style value '23' represents the yyyy-mm-dd format. Different style values can be used for different date and time formats.

Date Formats

Here's a full list of Date format codes: