Date Time Function

Name
Description
ADDDATE()
Add time values (intervals) to a date value
ADDTIME()
Add time
CONVERT_TZ()
Convert from one timezone to another
CURDATE()
Return the current date
CURTIME()
Return the current time
DATE_ADD()
Add time values (intervals) to a date value
DATE_FORMAT()
Format date as specified
DATE_SUB()
Subtract a time value (interval) from a date
DATE()
Extract the date part of a date or datetime expression
DATEDIFF()
Subtract two dates
DAY()
Synonym for DAYOFMONTH()
DAYNAME()
Return the name of the weekday
DAYOFMONTH()
Return the day of the month (0-31)
DAYOFWEEK()
Return the weekday index of the argument
DAYOFYEAR()
Return the day of the year (1-366)
HOUR()
Extract the hour
LAST_DAY
Return the last day of the month for the argument
LOCALTIME(), LOCALTIME
Synonym for NOW()
LOCALTIMESTAMP,
LOCALTIMESTAMP()
Synonym for NOW()
MAKEDATE()
Create a date from the year and day of year
MAKETIME()
Create time from hour, minute, second
MICROSECOND()
Return the microseconds from argument
MINUTE()
Return the minute from the argument
MONTH()
Return the month from the date passed
MONTHNAME()
Return the name of the month
NOW()
Return the current date and time
PERIOD_ADD()
Add a period to a year-month
PERIOD_DIFF()
Return the number of months between periods
QUARTER()
Return the quarter from a date argument
Name
Description
SEC_TO_TIME()
Converts seconds to 'HH:MM:SS' format
SECOND()
Return the second (0-59)
STR_TO_DATE()
Convert a string to a date
SUBDATE()
Synonym for DATE_SUB() when invoked with three arguments
SUBTIME()
Subtract times
SYSDATE()
Return the time at which the function executes
TIME_FORMAT()
Format as time
TIME_TO_SEC()
Return the argument converted to seconds
TIME()
Extract the time portion of the expression passed
TIMEDIFF()
Subtract time
TIMESTAMP()
With a single argument, this function returns the date or

datetime expression; with two arguments, the sum of the
arguments
TIMESTAMPADD()
Add an interval to a datetime expression
TIMESTAMPDIFF()
Subtract an interval from a datetime expression
TO_DAYS()
Return the date argument converted to days
UNIX_TIMESTAMP()
Return a UNIX timestamp
UTC_DATE()
Return the current UTC date
UTC_TIME()
Return the current UTC time
UTC_TIMESTAMP()
Return the current UTC date and time
WEEK()
Return the week number
WEEKDAY()
Return the weekday index
WEEKOFYEAR()
Return the calendar week of the date (1-53)
YEAR()
Return the year
YEARWEEK()
Return the year and week

Date Time Function

Uploaded by

Copyright:

Available Formats

Date Time Function

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Date Time Function

Uploaded by

Copyright:

Available Formats

Name

Add time values (intervals) to a date value

Convert from one timezone to another

Return the current date

Return the current time

Add time values (intervals) to a date value

Format date as specified

Subtract a time value (interval) from a date

Extract the date part of a date or datetime expression

Subtract two dates

Synonym for DAYOFMONTH()

Return the name of the weekday

Return the day of the month (0-31)

Return the weekday index of the argument

Return the day of the year (1-366)

Extract the hour

Return the last day of the month for the argument

Synonym for NOW()

Synonym for NOW()

Create a date from the year and day of year

Create time from hour, minute, second

Return the microseconds from argument

Return the minute from the argument

Return the month from the date passed

Return the name of the month

Return the current date and time

Add a period to a year-month

Return the number of months between periods

Return the quarter from a date argument

Converts seconds to 'HH:MM:SS' format

Return the second (0-59)

Convert a string to a date

Synonym for DATE_SUB() when invoked with three arguments

Return the time at which the function executes

Return the argument converted to seconds

Extract the time portion of the expression passed

With a single argument, this function returns the date or

Add an interval to a datetime expression

Subtract an interval from a datetime expression

Return the date argument converted to days

Return a UNIX timestamp

Return the current UTC date

Return the current UTC time

Return the current UTC date and time

Return the week number

Return the weekday index

Return the calendar week of the date (1-53)

Return the year

Return the year and week

You might also like