-- valid date value
select cast ('1945-12-31' as date);
select cast ('1946-01-01' as date);
select cast ('0004-05-06' as date);
select cast ('2001-11-12 01:02:03' as date);
select cast (' 2001-11-12 01:02:03' as date);
select cast (' 1946-01-01' as date);

--date
-- invalid date value
select cast ('2001-01-32' as date);
select cast ('2001-13-30' as date);
select cast ('0000-00-00' as date);

--valid timestamp value
select cast ('1945-12-31 23:59:59.0"' as timestamp);
select cast ('1945-12-31 23:59:59.1234' as timestamp);
select cast ('1970-01-01 00:00:00' as timestamp);
--timestamp
--invalid timestamp value
select cast ('0000-00-00 00:00:00' as timestamp);