Structs§
- Date
AddFunction - DATEADD function - Add interval to date
- Date
Diff Function - DATEDIFF function - Calculate difference between dates
- Date
Time Constructor - DATETIME constructor - Create datetime from components
- DayFunction
- DAY function - extracts day of month from date (1-31)
- DayName
Function - DAYNAME function - returns full day name (Monday, Tuesday, etc.)
- DayOf
Week Function - DAYOFWEEK function - returns day of week as number (0=Sunday, 6=Saturday)
- From
Unix Time - FROM_UNIXTIME - Convert Unix epoch timestamp to datetime
- IsLeap
Year Function - ISLEAPYEAR function - returns true if the year is a leap year
- Month
Function - MONTH function - extracts month from date (1-12)
- Month
Name Function - MONTHNAME function - returns the month name
- NowFunction
- NOW function - Returns current datetime
- Parse
Date Time Function - PARSE_DATETIME - Parse datetime with custom format string
- Parse
Date Time UtcFunction - PARSE_DATETIME_UTC - Parse datetime and explicitly interpret as UTC
- Quarter
Function - QUARTER function - returns the quarter of the year (1-4)
- Time
Bucket - TIME_BUCKET - Round timestamps down to bucket boundaries
- Today
Function - TODAY function - Returns current date
- Unix
Timestamp - UNIX_TIMESTAMP - Convert datetime to Unix epoch timestamp
- Week
OfYear Function - WEEKOFYEAR function - returns the ISO week number (1-53)
- Year
Function - YEAR function - extracts year from date
Functions§
- parse_
datetime - register_
date_ time_ functions - Register all date/time functions