On 01/21/2013 07:26 AM, Rich Shepard wrote:
   What is the behavior if a column data type is timestamptz but there is
only the date portion available? There must be a default time; can that be
defined?

Easy enough to test:

test=# create table ts_test(ts_fld timestamp with time zone);
CREATE TABLE

test=# insert into ts_test VALUES ('2013-01-21');
INSERT 0 1

test=# SELECT * from ts_test ;
         ts_fld
------------------------
 2013-01-21 00:00:00-08

Not sure you can change the default supplied by Postgres, but you can on your end:

test=# insert into ts_test VALUES ('2013-01-21'::date + interval '6' hour);
INSERT 0 1

test=# SELECT * from ts_test ;
         ts_fld
------------------------
 2013-01-21 00:00:00-08
 2013-01-21 06:00:00-08
(2 rows)


Rich





--
Adrian Klaver
adrian.kla...@gmail.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to