Date formatting

Display dates in different formats.

DATE_FORMAT

DATE_FORMAT (MySQL) or TO_CHAR (PostgreSQL) formats a date as text in a given pattern.

SELECT DATE_FORMAT(order_date, '%Y-%m-%d') AS metin FROM orders;

This query converts the date to YYYY-MM-DD text.

DATE_FORMAT(order_date, '%Y-%m-%d') AS metin is selected from orders.

Format tokens differ by database: MySQL uses %Y, %m, %d; PostgreSQL uses YYYY, MM, DD.

Format order_date as %Y-%m-%d text from orders.

Show example solution

SELECT DATE_FORMAT(order_date, '%Y-%m-%d') AS metin
FROM orders

Format

SELECT ____(order_date, '%Y-%m-%d') FROM orders;

Show answer

SELECT DATE_FORMAT(order_date, '%Y-%m-%d') FROM orders;