From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | timestamps and dates |
Date: | 2003-04-28 15:48:32 |
Message-ID: | Pine.LNX.4.21.0304281636330.2388-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm sure this has cropped up before but I can't find the messages so sorry to
bother everyone...
I have two systems (both linux) one, let's call it A, running 7.3.1 and one, B,
7.3.2, although I think that difference is irrelevent as I show below.
Trying:
SELECT '2003 Jul 08'::timestamptz
on A gives me the expected:
'2003-07-08 00:00:00+01'
while on B I get:
'2003-07-07 23:59:00+01'
(time zone being set for the UK)
I even reran the regression tests and on B I get:
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
And when I look at the output I do indeed correct results like:
SELECT '' AS to_timestamp_3, to_timestamp('1985 January 12', 'YYYY FMMonth DD');
to_timestamp_3 | to_timestamp
----------------+------------------------------
| Sat Jan 12 00:00:00 1985 PST
(1 row)
So obviously I'm missing something (and it appears not to be a version
thing). Any help?
TIA
--
Nigel J. Andrews
From | Date | Subject | |
---|---|---|---|
Next Message | David Link | 2003-04-28 15:51:46 | Re: pq_recvbuf: unexpected EOF |
Previous Message | scott.marlowe | 2003-04-28 15:42:56 | Re: > 16TB worth of data question |