DATEV2
DATEV2
Description
Syntax:
DATEV2The current range of DATEV2 is ['0000-01-01','9999-12-31'], and it will be printed as 'YYYYY-MM-DD' by default.
Note
DATEV2 is more efficient than DATE. The memory usage of DATEV2 is only half of that of DATE.
Example
mysql> SELECT CAST('2003-12-31 01:02:03' as DATEV2);
-> '2003-12-31'Keywords
DATEV2