DATE

SinceVersion 1.2.0

DATE

Description

Syntax

date Date type, the current range of values is [‘0000-01-01’,’9999-12-31’], and the default print form is ‘yyyy-MM-dd’.

example

1. SELECT DATE('2003-12-31 01:02:03');
2. +-----------------------------+
3. | DATE('2003-12-31 01:02:03') |
4. +-----------------------------+
5. | 2003-12-31                  |
6. +-----------------------------+

keywords

DATE