Date & Time Functions
Learn about date and time functions in MariaDB Server. This section details SQL functions for manipulating, formatting, and calculating with date and time values for various applications.
Date and Time UnitsADD_MONTHSADDDATEADDTIMECONVERT_TZCURDATECURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPCURTIMEDATE FUNCTIONDATE_ADDDATE_FORMATDATE_SUBDATEDIFFDAYDAYNAMEDAYOFMONTHDAYOFWEEKDAYOFYEAREXTRACTFORMAT_PICO_TIMEFROM_DAYSFROM_UNIXTIMEGET_FORMATHOURLAST_DAYLOCALTIMELOCALTIMESTAMPMAKEDATEMAKETIMEMICROSECONDMicroseconds in MariaDBMINUTEMONTHMONTHNAMENOWPERIOD_ADDPERIOD_DIFFQUARTERSEC_TO_TIMESECONDSTR_TO_DATESUBDATESUBTIMESYSDATETIMETIME_FORMATTIME_TO_SECTIMEDIFFTIMESTAMPTIMESTAMPADDTIMESTAMPDIFFTO_DAYSTO_SECONDSTRUNCUNIX_TIMESTAMPUTC_DATEUTC_TIMEUTC_TIMESTAMPWEEKWEEKDAYWEEKOFYEARYEARYEARWEEK
Last updated
Was this helpful?