Date and time functions
📄️ add_months
Description
📄️ adddate,date_add
This function is a synonym of dateadd.
📄️ convert_tz
Description
📄️ curdate,current_date
Description
📄️ current_timestamp
Description
📄️ curtime,current_time
Description
📄️ date
Description
📄️ date_add,adddate
Description
📄️ date_diff
Description
📄️ date_format
Description
📄️ date_slice
Description
📄️ date_sub,subdate
Description
📄️ date_trunc
Description
📄️ datediff
Description
📄️ day
Description
📄️ dayofweek_iso
Description
📄️ dayname
Description
📄️ dayofmonth
Description
📄️ dayofweek
Description
📄️ dayofyear
Description
📄️ days_add
Description
📄️ days_diff
Description
📄️ days_sub
Description
📄️ from_days
Description
📄️ from_unixtime
Description
📄️ hour
Description
📄️ hours_add
Description
📄️ hours_diff
Description
📄️ hours_sub
Description
📄️ jodatime_format
Description
📄️ last_day
Description
📄️ makedate
Description
📄️ microseconds_add
Description
📄️ microseconds_sub
Description
📄️ milliseconds_diff
Description
📄️ minute
Description
📄️ minutes_add
Description
📄️ minutes_diff
Description
📄️ minutes_sub
Description
📄️ month
Description
📄️ monthname
Description
📄️ months_add
Description
📄️ months_diff
Description
📄️ months_sub
Description
📄️ next_day
Description
📄️ now, current_timestamp, localtime, localtimestamp
Description
📄️ previous_day
Description
📄️ quarter
Description
📄️ second
Description
📄️ seconds_add
description
📄️ seconds_diff
Description
📄️ seconds_sub
Description
📄️ str2date
Description
📄️ str_to_date
Description
📄️ str_to_jodatime
Description
📄️ time_format
Formats TIME-type values in the specified format.
📄️ time_slice
Description
📄️ time_to_sec
Description
📄️ timediff
Description
📄️ timestamp
Description
📄️ timestampadd
Description
📄️ timestampdiff
Description
📄️ to_date
Description
📄️ to_days
Description
📄️ to_iso8601
Description
📄️ to_tera_date
Description
📄️ to_tera_timestamp
Description
📄️ unix_timestamp
Description
📄️ utc_time
Description
📄️ utc_timestamp
Description
📄️ week
Description
📄️ week_iso
Description
📄️ weekofyear
Description
📄️ weeks_add
Description
📄️ weeks_diff
Description
📄️ weeks_sub
Description
📄️ year
Description
📄️ years_add
description
📄️ years_diff
Description
📄️ years_sub
Description
📄️ yearweek
Description