| --- |
| { |
| "title": "TIMESTAMPDIFF", |
| "language": "en" |
| } |
| --- |
| |
| <!-- |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, |
| software distributed under the License is distributed on an |
| "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| KIND, either express or implied. See the License for the |
| specific language governing permissions and limitations |
| under the License. |
| --> |
| |
| ## timestampdiff |
| ### description |
| #### Syntax |
| |
| `INT TIMESTAMPDIFF(unit, DATETIME datetime_expr1, DATETIME datetime_expr2)` |
| |
| Returns datetime_expr2 − datetime_expr1, where datetime_expr1 and datetime_expr2 are date or datetime expressions. |
| |
| The unit for the result (an integer) is given by the unit argument. |
| |
| The legal values for unit are the same as those listed in the description of the TIMESTAMPADD() function. |
| |
| ### example |
| |
| ``` |
| |
| MySQL> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01'); |
| +--------------------------------------------------------------------+ |
| | timestampdiff(MONTH, '2003-02-01 00:00:00', '2003-05-01 00:00:00') | |
| +--------------------------------------------------------------------+ |
| | 3 | |
| +--------------------------------------------------------------------+ |
| |
| MySQL> SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01'); |
| +-------------------------------------------------------------------+ |
| | timestampdiff(YEAR, '2002-05-01 00:00:00', '2001-01-01 00:00:00') | |
| +-------------------------------------------------------------------+ |
| | -1 | |
| +-------------------------------------------------------------------+ |
| |
| |
| MySQL> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55'); |
| +---------------------------------------------------------------------+ |
| | timestampdiff(MINUTE, '2003-02-01 00:00:00', '2003-05-01 12:05:55') | |
| +---------------------------------------------------------------------+ |
| | 128885 | |
| +---------------------------------------------------------------------+ |
| |
| ``` |
| ### keywords |
| TIMESTAMPDIFF |
