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, 1346👍, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...