NOW(): SELECT NOW(); : Current date and time in session time zone

CURRENT_TIMESTAMP: SELECT CURRENT_TIMESTAMP; : ANSI synonym for NOW()

CURDATE(): SELECT CURDATE(); : Current date (no time)

CURTIME(): SELECT CURTIME(); : Current time (no date)

SYSDATE(): SELECT SYSDATE(); : Time when function executes, not start of query

UTC_TIMESTAMP(): SELECT UTC_TIMESTAMP(); : Current UTC date and time

DATE(): SELECT DATE('2025-04-23 10:20:00'); : Extract date part from datetime

TIME(): SELECT TIME('2025-04-23 10:20:00'); : Extract time part

YEAR(): SELECT YEAR(order_date) FROM orders; : Extract year part

MONTH(): SELECT MONTH(order_date) FROM orders; : Extract month number

DAY(): SELECT DAY(order_date) FROM orders; : Extract day of month

DAYNAME(): SELECT DAYNAME(order_date) FROM orders; : Return weekday name

MONTHNAME(): SELECT MONTHNAME(order_date) FROM orders; : Return month name

DAYOFWEEK(): SELECT DAYOFWEEK(NOW()); : Return weekday index (1-7)

DAYOFYEAR(): SELECT DAYOFYEAR(NOW()); : Return day number in year

WEEK(): SELECT WEEK(NOW()); : ISO week number

QUARTER(): SELECT QUARTER(NOW()); : Quarter of year

HOUR(): SELECT HOUR(NOW()); : Hour part

MINUTE(): SELECT MINUTE(NOW()); : Minute part

SECOND(): SELECT SECOND(NOW()); : Second part

TIMESTAMP(): SELECT TIMESTAMP('2025-01-01','12:34:56'); : Create datetime from date and time

TIMESTAMPDIFF(): SELECT TIMESTAMPDIFF(DAY,'2025-01-01','2025-01-10'); : Difference between two
timestamps

TIMESTAMPADD(): SELECT TIMESTAMPADD(MONTH,3,NOW()); : Add interval to timestamp

DATEDIFF(): SELECT DATEDIFF('2025-02-01','2025-01-01'); : Difference in days

STR_TO_DATE(): SELECT STR_TO_DATE('23-04-2025','%d-%m-%Y'); : Convert string to date via format

DATE_FORMAT(): SELECT DATE_FORMAT(NOW(),'%d-%b-%Y'); : Format date/time to string

ADDDATE(): SELECT ADDDATE('2025-01-01', INTERVAL 7 DAY); : Add interval to date

SUBDATE(): SELECT SUBDATE('2025-01-08',INTERVAL 7 DAY); : Subtract interval

DATE_ADD(): SELECT DATE_ADD(NOW(), INTERVAL 1 HOUR); : Alias of ADDDATE for datetime

DATE_SUB(): SELECT DATE_SUB(NOW(), INTERVAL 1 HOUR); : Alias of SUBDATE for datetime

MAKEDATE(): SELECT MAKEDATE(2025,60); : Create date from year and day of year

MAKETIME(): SELECT MAKETIME(12,30,0); : Create time value

EXTRACT(): SELECT EXTRACT(ISOYEAR FROM NOW()); : Pull specified part from date/time

LAST_DAY(): SELECT LAST_DAY('2025-02-10'); : Return last day of month

CONVERT_TZ(): SELECT CONVERT_TZ(NOW(),'UTC','Asia/Kolkata'); : Convert datetime between zones

FROM_DAYS(): SELECT FROM_DAYS(737791); : Convert day number to date

TO_DAYS(): SELECT TO_DAYS(NOW()); : Convert date to number of days since zero date

UNIX_TIMESTAMP(): SELECT UNIX_TIMESTAMP(NOW()); : Get seconds since Unix epoch

FROM_UNIXTIME(): SELECT FROM_UNIXTIME(1700000000); : Convert epoch seconds to datetime

GET_FORMAT(): SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATE,'EUR')); : Return format string for
locale