MySQL date/time

<< Back to MYSQL

SELECT ADDDATE('1997-01-02', 31); 

mysql> SELECT ADDDATE('1997-01-02', 31);
+---------------------------------------------------------+
|         DATE_ADD('1997-01-02', INTERVAL 31 DAY)         |
+---------------------------------------------------------+
|                       1997-02-02                        |
+---------------------------------------------------------+
1 row in set (0.00 sec)

SELECT DATE('2004-12-21 01:02:03');

mysql> SELECT DATE('2004-12-21 01:02:03');
+---------------------------------------------------------+
|              DATE('2004-12-21 01:02:03')                |
+---------------------------------------------------------+
|                     2004-12-21                          |
+---------------------------------------------------------+
1 row in set (0.00 sec)

Related Links:

• MySQL Create Database
• MySQL DAYOFWEEK() Function
• MySQL DAYOFYEAR() Function
• MySQL From_days() Function
• MySQL Hour() Function
• MySQL ADDTIME() Function
• MySQL CURRENT_TIME() Function
• MySQL CURRENT_TIMESTAMP() Function
• MySQL last_day() Function
• MySQL localtime() Function
• MySQL localtimestamp() Function
• MySQL makedate() Function
• MySQL maketime() Function
• MySQL microsecond() Function
• MySQL minute() Function
• MySQL month() Function
• MySQL vs SQL
• MySQL monthname() Function
• MySQL now() Function
• MySQL period_add() Function
• MySQL period_diff() Function
• MySQL quarter() Function
• MySQL sec_to_time() Function
• MySQL Sysdate() Function
• MySQL second() Function
• MySQL Subdate() Function
• MySQL Subtime() Function
• MySQL time() Function
• MySQL time_to_sec() Function
• MySQL time_format() Function
• MySQL to_day() Function
• MySQL timediff() Function
• MySQL timestamp() Function
• MySQL weekday() Function
• MySQL Math SIN() Function
• MySQL week() Function
• MySQL weekofyear() Function
• MySQL Math
• MySQL Math ABS() Function
• MySQL Math ACOS() Function
• MySQL Math SIGN() Function
• MySQL Math SQRT() Function
• MySQL Math SUM() Function
• MySQL Math TAN() Function
• MySQL Math ATAN2() Function
• MySQL Drop Table
• MySQL View
• MySQL Queries
• MySQL Insert Statement
• MySQL Update Statement
• MySQL Math TRUNCATE() Function
• MySQL Math ASIN() Function
• MySQL Math ATAN() Function
• MySQL Math MIN() Function
• MySQL Math AVG() Function
• MySQL Math CEIL() Function
• MySQL Math CEILING() Function
• MySQL Math COS() Function
• MySQL Math COT() Function
• MySQL Math COUNT() Function
• MySQL Math DEGREES() Function
• MySQL Math DIV() Function
• MySQL Math EXP() Function
• MySQL Math FLOOR() Function
• MySQL Math GREATEST() Function
• MySQL Math LEAST() Function
• MySQL Math LN() Function
• MySQL Math LOG10() Function
• MySQL Math LOG() Function
• MySQL Math LOG2() Function
• MySQL Math MAX() Function
• MySQL Math MOD() Function
• Learn MySQL Tutorial
• MySQL Math PI() Function
• MySQL Math POWER() Function
• MySQL Math POW() Function
• MySQL Math RADIANS() Function
• MySQL Math RAND() Function
• MySQL Math ROUND() Function
• MySQL String
• MySQL String CONCAT_WS() Function
• MySQL String CHARACTER_LENGTH() Function
• MySQL String CONCAT() Function
• MySQL String ELT() Function
• MySQL String EXPORT_SET() Function
• MySQL String RTRIM() Function
• MySQL String FIELD() Function
• MySQL String FIND_IN_SET() Function
• MySQL String FORMAT() Function
• MySQL String FROM_BASE64() Function
• MySQL String HEX() Function
• MySQL String INSERT() Function
• MySQL String INSTR() Function
• MySQL String LCASE() Function
• MySQL String LEFT() Function
• MySQL String LENGTH() Function
• MySQL String like() Function
• MySQL String LOAD_FILE() Function
• MySQL String LOCATE() Function
• MySQL String LOWER() Function
• MySQL String LPAD() Function
• MySQL String LTRIM() Function
• MySQL String MAKE_SET() Function
• MySQL String MID() Function
• MySQL String OCTET_LENGTH() Function
• MySQL String OCT() Function
• MySQL String ORD() Function
• MySQL String POSITION() Function
• MySQL String QUOTE() Function
• MySQL String REPEAT() Function
• MySQL String REPLACE() Function
• MySQL String REVERSE() Function
• MySQL String SPACE() Function
• MySQL String RIGHT() Function
• MySQL String RPAD() Function
• MySQL String SOUNDEX() Function
• MySQL String UNHEX() Function
• MySQL String UCASE() Function
• MySQL String STRCMP() Function
• MySQL String SUBSTR() Function
• MySQL String SUBSTRING_INDEX() Function
• MySQL String SUBSTRING() Function
• MySQL String Trim() Function
• MySQL String UPPER() Function
• MySQL Drop Database
• MySQL Create Table
• MySQL Alter Table
• MySQL Truncate Table
• MySQL Delete Statement
• MySQL Select Statement
• MySQL Group By Clause
• Top 58 MySql Interview Questions (2021)
• MySQL Features
• MySQL Data Types
• MySQL regexp_like() function
• MySQL regexp_replace() Function
• MySQL regexp_substr() function
• MySQL Select Database
• MySQL Where Clause
• MySQL Distinct Clause
• MySQL From Clause
• MySQL Order By Clause
• MySQL Having Clause
• MySQL AND Condition
• MySQL average()
• MySQL min()
• MySQL max()
• MySQL Literals
• MySQL OR Condition
• MySQL AND and OR Condition
• MySQL IS NULL Condition
• MySQL LIKE Condition
• MySQL IN Condition
• MySQL NOT Condition
• MySQL IS NOT NULL Condition
• MySQL first()
• MySQL BETWEEN Condition
• MySQL Join
• MySQL count()
• MySQL sum()
• MySQL last()
• MySQL Comments
• MySQL not regexp Operator
• MySQL Regexp Operator
• MySQL regexp_instr() function
• MySQL Cursor
• MySQL Functions
• MySQL Date and Time
• MySQL PROCEDURE
• MySQL Trigger
• MySQL not like Operator
• MySQL date/time
• MySQL DATE() Function
• MySQL DATE_ADD() Function
• MySQL ADDDATE() Function
• MySQL CURDATE() Function
• MySQL CURRENT_DATE() Function
• MySQL DATE_FORMAT() Function
• MySQL DATEDIFF() Function
• MySQL DAY() Function
• MySQL CURTIME() Function
• MySQL DAYNAME() Function
• MySQL DAYOFMONTH() Function
• MySQL str_to_date() Function

Related Links