How to get today's date in sql?

Getting today's date in SQL depends on which database system you're using, but here are the most common methods:

For MySQL: ```sql SELECT CURDATE(); -- returns '2024-01-15' SELECT NOW(); -- returns datetime '2024-01-15 14:30:45' For SQL Server: SELECT GETDATE(); -- returns datetime SELECT CAST(GETDATE() AS DATE); -- returns date only For Oracle: SELECT SYSDATE FROM DUAL; -- returns datetime SELECT TRUNC(SYSDATE) FROM DUAL; -- returns date only For PostgreSQL: SELECT CURRENT_DATE; -- returns date SELECT NOW(); -- returns datetime with timezone SQLite: SELECT DATE('now'); -- returns current date Pro tip: If you need the date in a specific format, most databases have formatting functions like DATE_FORMAT() in MySQL or FORMAT() in SQL Server!