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, 249🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...