On 2013-01-21, Gavan Schneider <pg-...@snkmail.com> wrote: > On Monday, January 21, 2013 at 06:53, Adrian Klaver wrote: > .... > timezones I have been learning a lot from the side. > > Taking another tangent I would much prefer the default time to > be 12:00:00 for the conversion of a date to timestamp(+/-timezone). > > Propose: '2013-12-25'::timestamp ==> 2013-12-25 12:00:00 > > The benefit of the midday point is that the actual date will not > change when going through the timezone conversion.
that does not work, anywhere in the world, any time of day,it's always a different day somewhere (American Samoa vs Rarotonga be an extreme example, but one or the other will qualify if nowhere else does) If you want a date field use a date field, you can't reliably fake it using timestamptz -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
