Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

Examples with Datetime Types

Date Examples

Insert dates that have different formats and display the output:

Copy
create table datetable (start_date date, end_date date);

Copy
insert into datetable values ('2008-06-01','2008-12-31'); insert into datetable values ('Jun 1,2008','20081231');

Copy
select * from datetable order by 1; start_date | end_date ------------------------ 2008-06-01 | 2008-12-31 2008-06-01 | 2008-12-31

If you insert a time stamp value into a DATE column, the time portion is ignored and only the date loaded.

Time Stamp Examples

If you insert a date into a TIMESTAMP or TIMESTAMPTZ column, the time defaults to midnight. For example, if you insert the literal 20081231, the stored value is 2008-12-31 00:00:00.

To change the time zone for the current session, use the SET command to set the timezone configuration parameter.

Insert timestamps that have different formats and display the output:

Copy
create table tstamp(timeofday timestamp, timeofdaytz timestamptz); insert into tstamp values('Jun 1,2008 09:59:59', 'Jun 1,2008 09:59:59 EST' ); insert into tstamp values('Dec 31,2008 18:20','Dec 31,2008 18:20'); insert into tstamp values('Jun 1,2008 09:59:59 EST', 'Jun 1,2008 09:59:59); timeofday --------------------- 2008-06-01 09:59:59 2008-12-31 18:20:00 (2 rows)