Re: timestamps and dates - Mailing list pgsql-general

From Tom Lane
Subject Re: timestamps and dates
Date
Msg-id 19050.1051546616@sss.pgh.pa.us
Whole thread Raw
In response to timestamps and dates  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> SELECT '2003 Jul 08'::timestamptz
> while on B I get:
>     '2003-07-07 23:59:00+01'
> (time zone being set for the UK)

Is machine B perhaps using leap-second-aware timekeeping?  Postgres
doesn't cope with that ...

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problems restoring 7.2.1 dump to 7.3.2
Next
From: Jerome Alet
Date:
Subject: Re: SQL schema to LDAP schema ?