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, 253🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...