timestamps and dates

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

Responses

Browse pgsql-general by date

  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