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, 1742🔥, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...