Date Functions
function
Built-in functions for working with date and time values in MySQL.
Syntax
NOW() CURDATE() DATE_FORMAT() DATEDIFF() DATE_ADD()
Example
sql
SELECT NOW(); -- 2024-01-15 14:30:00
SELECT CURDATE(); -- 2024-01-15
SELECT DATE_FORMAT(created_at, '%d/%m/%Y') FROM posts;
SELECT DATEDIFF(NOW(), created_at) AS days_old FROM posts;
SELECT DATE_ADD(NOW(), INTERVAL 30 DAY);
SELECT YEAR(created_at), MONTH(created_at) FROM posts;
SELECT UNIX_TIMESTAMP(created_at) FROM posts;