メインコンテンツまでスキップ
バージョン: 2.5

datediff

Description​

expr1 から expr2 までの日付を計算し、日数で結果を返します。

expr1 と expr2 は有効な DATE または DATETIME 式です。

注意: 計算には値の日付部分のみが使用されます。

Syntax​

INT DATEDIFF(DATETIME expr1,DATETIME expr2)`

Examples​

MySQL > select datediff(CAST('2007-12-31 23:59:59' AS DATETIME), CAST('2007-12-30' AS DATETIME));
+-----------------------------------------------------------------------------------+
| datediff(CAST('2007-12-31 23:59:59' AS DATETIME), CAST('2007-12-30' AS DATETIME)) |
+-----------------------------------------------------------------------------------+
|                                                                                 1 |
+-----------------------------------------------------------------------------------+

MySQL > select datediff(CAST('2010-11-30 23:59:59' AS DATETIME), CAST('2010-12-31' AS DATETIME));
+-----------------------------------------------------------------------------------+
| datediff(CAST('2010-11-30 23:59:59' AS DATETIME), CAST('2010-12-31' AS DATETIME)) |
+-----------------------------------------------------------------------------------+
|                                                                               -31 |
+-----------------------------------------------------------------------------------+