date Data Type

date data expresses a date without a specified time.

Detail Info
Quick Syntax DATE '2007-02-01'
Size 1 byte
Min value 4713 BC
Max value 5874897 AD
Resolution 1 day

Syntax 

DATE ' yyyy - mm - dd '

Details 

Valid casts 

From date 

You can cast date to:

To date 

You cannot cast any other type to date.

Examples 

SELECT DATE '2007-02-01' AS date_v;
   date_v
------------
 2007-02-01