DATE datatype in Teradata

DATE is the datatype used for storing date values in a table.

Example code:
CREATE TABE tbl_emp
(id INT,
dateofbirth DATE)


You can also specify the format while creating table like this,
CREATE TABE tbl_emp
(id INT,
dateofbirth DATE FORMAT ’YYYY-MM-DD’ NOT NULL)