What are Date and Time Data Types in MySQL

Q

What Are Date and Time Data Types in MySQL?

✍: FYIcenter.com

A

MySQL supports the following date and time data types:

  • DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD".
  • DATETIME - A date with the time of day in the range of '1000-01-01 00:00:00' and '9999-12-31 23:59:59'. Default DATETIME format is "YYYY-MM-DD HH:MM:SS".
  • TIMESTAMP - A timestamp. The range is '1970-01-01 00:00:00' to partway through the year 2037. Default DATETIME format is "YYYY-MM-DD HH:MM:SS".
  • TIME - A time. The range is '-838:59:59' to '838:59:59'. Default TIME format is "HH:MM:SS".
  • TIME - A time. The range is '-838:59:59' to '838:59:59'. Default TIME format is "HH:MM:SS".
  • YEAR - A year in 4 digits in the range of 1901 and 2155. Default YEAR format is "YYYY".

 

Writing Date and Time Literals in MySQL

Introduction to Date and Time Handling in MySQL

Introduction to Date and Time Handling in MySQL

⇑⇑ MySQL Database Tutorials

2018-03-24, 1491🔥, 0💬