Date and time report functions.
NOW() - Returns the current date and time.
DATE() - Returns the current date.
TIME() - Returns the current time.
DATETOSTR(date) - Converts a date constituent of DateTime value to a string.
DATETIMETOSTR(datetime) - Converts a DateTime value to a string.
TIMETOSTR(time) - Converts a time constituent of DateTime value to a string.
STRTODATE(string) - Converts a string to a DateTime value. Time part is set to 0.
STRTODATETIME(string) - Converts a string to a DateTime value.
STRTOTIME(string) - Converts a time string to a DateTime value.
YEAR(date) - Returns the year of specified date.
MONTH(date) - Returns the month of specified date.
DAY(date) - Returns the day of specified date.
SYEAR(date) - Returns the year of date in string representation.
SMONTH(date) - Returns the month of date in string representation. Month which is less than 10 have zero in place of first symbol - "01", "02" and so on ...
SDAY(date) - Returns the day of date in string representation. Day which is less than 10 have zero in place of first symbol - "01", "02" and so on ...
DTOS(date) - Converts date to the string formatted as yyyymmdd.
STOD(string) - Converts string formatted as yyyymmdd to date value.
Next topic: Format functions