-- a specific date
select date '2014-07-01';

-- a timestamp
select timestamp '2014-04-28 21:20:19';

-- a time
select time '21:22:23';

Back to the SQL Feature Comparison