NOW()

NOW() is a SQL function in the Date/Time Functions category. Returns the current date and time as a timestamp. The syntax is NOW(). It accepts none. It returns current timestamp. A typical example: SELECT NOW(); -- 2026-06-06 14:30:00 INSERT INTO logs (created_at) VALUES (NOW()); A close relative is CURDATE(), which returns the current date without time. A close relative is DATE(), which extracts the date part from a datetime expression. A close relative is EXTRACT(), which extracts a specific part (YEAR, MONTH, DAY, HOUR, etc.) from a date. More about this category: Date and time functions — NOW, DATE, EXTRACT, DATEDIFF, DATE_ADD, DATE_FORMAT. Related Date/Time Functions entries: CURDATE(), DATE(), EXTRACT(), DATE_ADD(), DATE_SUB(), DATEDIFF(), DATE_FORMAT(), STR_TO_DATE(). This page is part of the free SQL Reference documentation covering 762+ statements, functions, and clauses, each with syntax, parameters, return values, and examples for MySQL, PostgreSQL, SQL Server, and SQLite.