Collections:
DATEDIFF() - Difference of Two Dates
How to calculate the difference between two dates using the DATEDIFF() function?
✍: FYIcenter.com
DATEDIFF(from_date, to_date) is a MySQL built-in function that calculates the difference from one date to another. For example:
SELECT DATEDIFF('2022-12-31 23:59:59','2022-12-30'); -- +----------------------------------------------+ -- | DATEDIFF('2022-12-31 23:59:59','2022-12-30') | -- +----------------------------------------------+ -- | 1 | -- +----------------------------------------------+ SELECT DATEDIFF('2022-11-30 23:59:59','2022-12-31'); -- +----------------------------------------------+ -- | DATEDIFF('2022-11-30 23:59:59','2022-12-31') | -- +----------------------------------------------+ -- | -31 | -- +----------------------------------------------+
Reference information of the DATEDIFF() function:
DATEDIFF(from_date, to_date): int Subtracts to_date from from_date and returns the difference in days. Arguments are date or date-and-time expressions and only the date parts are used in the calculation. Arguments, return value and availability: from_date: Required. The date to be subtracted from. to_date: Required. The date to be subtracted. int: Return value. The difference in days. Available since MySQL 4.
⇒ DATE_ADD() - Adding Date/Time Interval
2023-11-17, 266🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...