Module datetime
Source - age
- AGE(date1, [date2]) - Age between dates or from date to now
- curdate
- CURDATE() / CURRENT_DATE() - Current date
- curtime
- CURTIME() / CURRENT_TIME() - Current time
- date
- DATE(datetime) - Extract date part
- date_format
- DATE_FORMAT(date, format) - Format date/time
- dateadd
- DATEADD(date, interval, unit) / DATE_ADD(date, INTERVAL n unit)
unit can be: ‘day’, ‘month’, ‘year’, ‘hour’, ‘minute’, ‘second’
- datediff
- DATEDIFF(date1, date2) - Days between two dates
- datesub
- DATESUB(date, interval, unit) / DATE_SUB(date, INTERVAL n unit)
- day
- DAY(date) / DAYOFMONTH(date) - Extract day of month (1-31)
- dayname
- DAYNAME(date) - Name of day (Monday, Tuesday, etc.)
- dayofweek
- DAYOFWEEK(date) - Day of week (1=Sunday, 7=Saturday)
- dayofyear
- DAYOFYEAR(date) - Day of year (1-366)
- from_unixtime
- FROM_UNIXTIME(timestamp) - Convert Unix timestamp to datetime
- hour
- HOUR(time) - Extract hour (0-23)
- minute
- MINUTE(time) - Extract minute (0-59)
- month
- MONTH(date) - Extract month (1-12)
- monthname
- MONTHNAME(date) - Name of month (January, February, etc.)
- now
- NOW() / CURRENT_TIMESTAMP() - Current date and time
- quarter
- QUARTER(date) - Quarter of year (1-4)
- second
- SECOND(time) - Extract second (0-59)
- time
- TIME(datetime) - Extract time part
- timestampdiff
- TIMESTAMPDIFF(unit, datetime1, datetime2) - Difference in specified units
- unix_timestamp
- UNIX_TIMESTAMP(date) - Seconds since Unix epoch
- week
- WEEK(date) - Week number of year (0-53)
- year
- YEAR(date) - Extract year