Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
SELECT order_id, DATE_FORMAT(created_at, '%d %M %Y') AS order_date, DATEDIFF(NOW(), created_at) AS days_old, DATE_ADD(created_at, INTERVAL 30 DAY) AS due_date, YEAR(created_at) AS order_year FROM orders WHERE created_at >= '2025-01-01';
Result
Open