Date data types in MySQLDATE TypeDATEFormat : YYYY-MM-DDRange 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 DATETIMEfsp: is the fraction of second from .000000 to .999999 TIMERange of value : '00:00:00.000000' to '23:59:59.999999' Example : News_time TIMEfsp: is the fraction of second from .000000 to .999999 TIMESTAMPvalues 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 YEARValue of year is stored as YYYY.
This article is written by plus2net.com team.
![]() ![]() |