: DATE_ADD : Date Time Functions MySQL TUTORIALS

Navioo.com

MySQL TUTORIALS » Date Time Functions » DATE_ADD »

218.1 .

SELECT '2005-03-32' + INTERVAL 1 MONTH;

SELECT '2005-03-32' + INTERVAL 1 MONTH;

Hits: 1173

218.2 .

Date arithmetic operations require complete dates

Date arithmetic operations require complete dates

Hits: 979

218.3 .

If the resulting date has a day that is larger than the maximum day for the new month, the day is adjusted to the maximum days in the new month.

If the resulting date has a day that is larger than the maximum day for the new month, the day is adjusted to the maximum days in the new month.

Hits: 943

218.4 .

SELECT DATE_ADD('1999-01-01', INTERVAL 1 HOUR);

SELECT DATE_ADD('1999-01-01', INTERVAL 1 HOUR);

Hits: 930

218.5 .

If you add to or subtract from a date value something that contains a time part, the result is automatically converted to a datetime value.

If you add to or subtract from a date value something that contains a time part, the result is automatically converted to a datetime value.

Hits: 967

218.6 .

SELECT DATE_ADD('1992-12-31 23

SELECT DATE_ADD('1992-12-31 23

Hits: 948

218.7 .

SELECT DATE_SUB('1998-01-02', INTERVAL 31 DAY);

SELECT DATE_SUB('1998-01-02', INTERVAL 31 DAY);

Hits: 1036

218.8 .

SELECT DATE_ADD('1998-01-01 00

SELECT DATE_ADD('1998-01-01 00

Hits: 958

218.9 .

SELECT DATE_SUB('1998-01-01 00

SELECT DATE_SUB('1998-01-01 00

Hits: 1047

218.10 .

SELECT DATE_ADD('1997-12-31 23

SELECT DATE_ADD('1997-12-31 23

Hits: 1091

218.11 .

SELECT DATE_ADD('1997-12-31 23

SELECT DATE_ADD('1997-12-31 23

Hits: 1059

218.12 .

SELECT DATE_ADD('1997-12-31 23

SELECT DATE_ADD('1997-12-31 23

Hits: 1018

218.13 .

Adding one month to start date

Adding one month to start date

Hits: 1231

218.14 .

Adding one year to a date

Adding one year to a date

Hits: 1075

218.15 .

Adding one month to a date

Adding one month to a date

Hits: 999

218.16 .

Adding one day to a date

Adding one day to a date

Hits: 1017

218.17 .

DATE_ADD(curdate(), INTERVAL '1.1' YEAR_MONTH); (with dot)

DATE_ADD(curdate(), INTERVAL '1.1' YEAR_MONTH); (with dot)

Hits: 951

218.18 .

DATE_ADD(curdate(), INTERVAL '1-1' YEAR_MONTH); (with minus sign)

DATE_ADD(curdate(), INTERVAL '1-1' YEAR_MONTH); (with minus sign)

Hits: 1051

218.19 .

DATE_ADD(curdate(), INTERVAL 1.1 SECOND_MICROSECOND); (with dot)

DATE_ADD(curdate(), INTERVAL 1.1 SECOND_MICROSECOND); (with dot)

Hits: 1101

218.20 .

DATE_ADD(curdate(), INTERVAL '1 1' DAY_HOUR);(wihtout

DATE_ADD(curdate(), INTERVAL '1 1' DAY_HOUR);(wihtout

Hits: 1021

Follow Navioo On Twitter

MySQL TUTORIALS

Navioo

Date Time Functions
» DATE_ADD

Aggregate Functions

Aggregate Functions

Cast Functions Operators

Cast Functions Operators

Comparison Functions Operators

Comparison Functions Operators

Control Flow Functions

Control Flow Functions

Cursor

Data Dictionary

Data Dictionary

Data Types

Database

Date Time Functions

Date Time Functions

Encryption Compression Functions

Encryption Compression Functions

Information Functions

Information Functions

Insert Update Delete

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Math Numeric Functions

Miscellaneous Functions

Miscellaneous Functions

MySQL Utilities

MySQL Utilities

Privilege

Procedure Function

Procedure Function

Regular Expressions

Regular Expressions

Select Query

String Functions

String Functions

Subquery

Table

Table Join

Trigger

View

hits counter