On 2013-01-21, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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? No, if you don't specify the time 00:00 (midnight) is used. if you don't specify a timezone it's local midnight, so viewed from a neighbouring timezone it could be 1AM or 11pm the previous day. -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
