How to convert timestamps to date format using sql

To convert timestamps in SQL to date format, you can use the TO_CHAR() function: TO_CHAR(timestamp_column, 'YYYY-MM-DD') to convert timestamps to date strings. Other date formats can be used, such as 'YYY-MM-DD HH24:MI:SS' (date and time) and 'YYY-MM-DD HH:MI:SS AM' (date and time, with AM/PM).

How to convert timestamps to date format in SQL

Conversion method:

Use TO_CHAR() function to convert the timestamp to a date string.

grammar:

 <code class="sql">TO_CHAR(timestamp_column, 'YYYY-MM-DD')</code>

parameter:

• timestamp_column: timestamp column that needs to be converted.
• 'YYYY-MM-DD': The required date format.

Example:

 <code class="sql">SELECT TO_CHAR(timestamp_column, 'YYYY-MM-DD') FROM table_name;</code>

Other formats:

In addition to 'YYYY-MM-DD' , other date formats can be used:

• 'YYYY-MM-DD HH24:MI:SS' : Date and time
• 'YYYY-MM-DD HH:MI:SS AM' : Date and time (with AM/PM)
• 'YYYY-MM-DD HH:MI:SS PM' : Date and time (with AM/PM)

Notice:

• Timestamps must be stored in Unix timestamp format.
• If the timestamp is not a Unix timestamp, you need to convert it to a Unix timestamp first.

The above is the detailed content of How to convert timestamps to date format using sql. For more information, please follow other related articles on the PHP Chinese website!