Function handles DATE / TIME in SQL - Part 1
In this article, Quantrimang lists all the important functions used to handle Date / Time in SQL.
In this article, Quantrimang lists all the important functions used to handle Date / Time in SQL. The list is based on MySQL RDBMS.
Date / time processing functions
NO ADDITIONAL DESCRIPTION 1 ADDDATE () Add a time period in date 2 ADDTIME () Add a time period to time 3 CONVERT_TZ () Time zone switch 4 CURDATE () Returns the current date 5 CURRENT_DATE () Returns date current 6 CURRENT_TIME () Returns the current time 7 CURRENT_TIMESTAMP () Returns the current date and time 8 CURTIME () Returns the current time 9 DATE_ADD () Plus time 10 DATE_FORMAT () Time value format 11th time DATE_SUB () Except time 12 DATE () Returns the date part of the time expression 13 DATEDIFF () Returns the difference between two time values 14 DAY () Returns the date order of the month (from 0 to 31) 15 DAYNAME () Returns the name of the day of the week 16 DAYOFMONTH () Returns the date of the month (from 0 to 31) 17 DAYOFWEEK () Returns the number of days of the week (1 = Sunday, 2 = Monday. . 7 = Saturday) 18 DAYOFYEAR () Returns the date of the year (from 1 to 366) 19 EXTRACT Extracts the time value from the original expression 20 FROM_DAYS () Converts a number to day 21 FROM_UNIXTIME () Returns the date of the representation for the original Unixtime parameter 22 HOUR () Returns the hour part from the time expression 23 LAST_DAY () Returns the corresponding value for the last day of the 24th month LOCALTIME () Returns the current date and time 25 LOCALTIMESTAMP () Returns About the current date and time 26 MAKEDATE () Returns a date with parameters passed into 27 MAKETIME () Returns the time value with the passed parameters 28 MICROSECOND () Returns the microsecond from the original expression 29 MINUTE ( ) Returns the minute value from the time expression 30 MONTH () Returns the month value from the time expression 31 MONTHNAME () Returns the month name from the time expression gi an 32 NOW () Returns the current date and time 33 PERIOD_ADD () Adds a time period for the month of the year 34 PERIOD_DIFF () Returns the number of months between periods 35 QUARTER () Returns the quarter value from the time expression 36 SEC_TO_TIME () Converts the number of seconds to the format 'HH: MM: SS' 37 SECOND () Returns the second value from the time expression 38 STR_TO_DATE () Converts a string to a 39 day SUBDATE () Except one time interval from date passed to 40 SUBTIME () Except for two time periods 41 SYSDATE () Returns the current date and time 42 TIME_FORMAT () Time value format 43 TIME_TO_SEC () Returns the number of seconds converted from the parameter initial 44 TIME () Returns the time value from the original expression 45 TIMEDIFF () Returns the difference between two time values 46 TIMESTAMP () Returns the datetime expression 47 TIMESTAMPADD () Adds the time interval specified in the initial parameter 48 TIMESTAMPDIFF () Returns an integer representing the time difference between two expressions 49 TO_DAYS () Returns the number of days between the date value and year 0 50 UNIX_TIMESTAMP () Returns the number of seconds under Unix timestamp from the original expression 51 UTC_DATE () Returns the current UTC date 52 UTC_TIME () Returns the current UTC time 53 UTC_TIMESTAMP () Returns the current UTC date and time 54 WEEKDAY () Returns the weekday index (0 = Monday, 1 = Tuesday . 6 = Sunday) 55 WEEKOFYEAR () Returns the week number in the year of the time expression 56 YEAR () Returns The corresponding year of the original parameterDate data types in SQL
MySQL comes with data types to store date or date / time values in the database:
- DATE - YYYY-MM-DD format
- DATETIME - format: YYYY-MM-DD HH: MI: SS
- TIMESTAMP - format: YYYY-MM-DD HH: MI: SS
- YEAR - YYYY or YY format
With:
- Y is the year
- M is the month
- D is the date
- H is the hour
- MM is the minute
- SS is seconds
YYYY is the year saved as a four-digit number, YY is the year saved as a two-digit number; MM is saved as a two-digit month, for example July will be 07):
In the next section, Quan trimang will work with you to learn how to use all of the above functions with the syntax and specific examples, please remember to follow.
Previous article: Operator representing WILDCARD in SQL
Next lesson: Function handling DATE / TIME in SQL - Part 2
4 ★ | 1 Vote
You should read it
- Strptime () function in Python
- Strftime () function in Python
- Datetime in Python
- DATEDIFF function in SQL Server
- Current date and time in Python
- Function handles DATE / TIME in SQL - Part 2
- MONTH function in SQL Server
- GETUTCDATE function in SQL Server
- CURRENT_TIMESTAMP command in SQL Server
- Function sleep () in Python
- Convert the timestamp value in Python
- NOW function - The function returns the current date and time in Excel
Maybe you are interested
Cash flow from ETFs returns, Bitcoin bounces above the $65,000 mark after hitting a 2-month bottom
How To Fill Your Annual Tax Returns: Tips To Ease Your Life
How to Remove spaces and carriage returns in Word
Function Address - The function returns the address of a cell in Excel (usage, examples, examples)
ENCODEURL function - The function returns a query string with URL code in Excel
FILTERXML - Function that returns specified data from XML content using the specified XPath in Excel