Collections:
TIMESTAMPADD() - Incrementing Timestamp
How to increment a component of timestamp value using the TIMESTAMPADD() function?
✍: FYIcenter.com
TIMESTAMPADD(unit, interval, datetime) is a MySQL built-in function that updates a timestamp by incrementing a component. For example:
SELECT TIMESTAMPADD(MINUTE, 1, '2023-01-02'); -- +---------------------------------------+ -- | TIMESTAMPADD(MINUTE, 1, '2023-01-02') | -- +---------------------------------------+ -- | 2023-01-02 00:01:00 | -- +---------------------------------------+ SELECT TIMESTAMPADD(MINUTE, -1, '2023-01-02'); -- +----------------------------------------+ -- | TIMESTAMPADD(MINUTE, -1, '2023-01-02') | -- +----------------------------------------+ -- | 2023-01-01 23:59:00 | -- +----------------------------------------+ SELECT TIMESTAMPADD(WEEK, 1, '2023-02-28'); -- +-------------------------------------+ -- | TIMESTAMPADD(WEEK, 1, '2023-02-28') | -- +-------------------------------------+ -- | 2023-03-07 | -- +-------------------------------------+ SELECT TIMESTAMPADD(MONTH, 1, '2023-03-31'); -- +--------------------------------------+ -- | TIMESTAMPADD(MONTH, 1, '2023-03-31') | -- +--------------------------------------+ -- | 2023-04-30 | -- +--------------------------------------+
Reference information of the TIMESTAMPADD() function:
TIMESTAMPADD(unit, interval, datetime): moddate Adds the integer expression interval to the timestamp expression datetime. The unit for interval is given by the unit argument, which should be one of the following values: MICROSECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR. Arguments, return value and availability: unit: Required. The timestamp component unit keyword. interval: Required. The integer value to increment by. datetime: Required. The starting timestamp. moddate: Return value. The incremented timestamp. Available since MySQL 4.0.
Related MySQL functions:
⇒ TIMESTAMPDIFF() - Difference in Timestamp Component
⇐ TIMESTAMP() - Adding Time to Timestamp
2023-11-17, 245🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...