SELECT
id,
DATE_FORMAT(date, '%Y') AS year,
DATE_FORMAT(date, '%m') AS month,
DATE_FORMAT(date, '%d') AS day,
date
FROM
orders;
SELECT
id,
date,
DATE_ADD(date, INTERVAL 1 DAY) AS new_date
FROM
orders;
SELECT
id,
date,
UNIX_TIMESTAMP(date) AS seconds_from_epoch
FROM
orders;
SELECT
COUNT(*) AS rows_count
FROM
orders
WHERE
date BETWEEN '1996-07-10 00:00:00' AND '1996-10-08 00:00:00';
SELECT
id,
date,
JSON_OBJECT('id', id, 'date', date) AS json_object
FROM
orders;
