Date data types in MySQL

DATE Type

DATE

Format : YYYY-MM-DD
Range of values:'1000-01-01' to '9999-12-31'

Example : News_date DATE

By default MySQL store in YYYY-MM-DD format

DATETIME [fsp]

Range of value : '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999' Example : News_datetime DATETIME

fsp: is the fraction of second from .000000 to .999999

TIME

Range of value : '00:00:00.000000' to '23:59:59.999999' Example : News_time TIME

fsp: is the fraction of second from .000000 to .999999

TIMESTAMP

values are stored as the number of seconds since the epoch ('1970-01-01 00:00:00' UTC)
fsp: is the fraction of second from .000000 to .999999

YEAR

Value of year is stored as YYYY.

This article is written by plus2net.com team.

plus2net.com

More on Alter or coy table , add update or delete records in SQL

Adding records to a table by insert command
Adding records with set option
Changing structure of the table by alter query
Create table query with if exists sql with php script
Creating a new table by using data from one table
Change the name of a table
Copying data from one table to another table
Delete records from a table with conditions
Delete table by using DROP sql
Update SQL commands
Inserting SUM, AVG data from one table column to other using group by command
Listing all tables and Database present in MySQL
Table Records are downloaded as .csv file

SQL Popular Tutorials

Order by displaying records Records Between two date ranges Some of the records by LIMIT query SQL SUM of data in columns