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