On 2013-01-21, Rich Shepard <rshepard@appl-ecosys.com> 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