Collections:
TIMESTAMP() - Adding Time to Timestamp
How to add a time value to a datetime value using the TIMESTAMP() function?
✍: FYIcenter.com
TIMESTAMP(datetime, time) is a MySQL built-in function that
adds a time value to a datetime value.
For example:
SELECT TIMESTAMP('2023-12-31 12:00:00', '12:00:00');
-- +---------------------------------------------+
-- | TIMESTAMP('2023-12-31 12:00:00','12:00:00') |
-- +---------------------------------------------+
-- | 2024-01-01 00:00:00 |
-- +---------------------------------------------+
SELECT TIMESTAMP('2023-12-31 12:00:00', '-48:00:00');
-- +-----------------------------------------------+
-- | TIMESTAMP('2023-12-31 12:00:00', '-48:00:00') |
-- +-----------------------------------------------+
-- | 2023-12-29 12:00:00 |
-- +-----------------------------------------------+
Reference information of the TIMESTAMP() function:
TIMESTAMP(datetime, time): dt Adds the second argument as a time value to the first argument and returns the result as a datetime value. Arguments, return value and availability: datetime: Required. The timestamp to be subtracted from. time: Optional. Default is '00:00:00'. The time value to be subtracted. dt: Return value. The updated timestamp. Available since MySQL 4.
Related MySQL functions:
⇒ TIMESTAMPADD() - Incrementing Timestamp
⇐ TIMEDIFF() - Difference of Two Timestamps
2023-11-17, 1907🔥, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...