On 2013-01-21, Gavan Schneider <pg-gts@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