Collections:
What Is TIMESTAMP Data Type in MySQL
What Is TIMESTAMP Data Type in MySQL?
✍: FYIcenter.com
A TIMESTAMP data type allows you to record a date and time like DATETIME data type. But it has some interesting features when used on a table column:
The tutorial exercise below provides you 2 equivalent ways to create a TIMESTAMP column:
CREATE TABLE links (lastDate TIMESTAMP); CREATE TABLE links (lastDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
⇒ Ways to Get the Current Time in MySQL
⇐ Date and Time Functions in MySQL
2018-03-13, 1664🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...