timestamps and dates

Поиск
Список
Период
Сортировка
От Nigel J. Andrews
Тема timestamps and dates
Дата
Msg-id Pine.LNX.4.21.0304281636330.2388-100000@ponder.fairway2k.co.uk
обсуждение исходный текст
Ответы Re: timestamps and dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: timestamps and dates  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Eric D Nielsen
Дата:
Сообщение: Doxygen/Javadoc-esque SQL DDL documentor?
Следующее
От: David Link
Дата:
Сообщение: Re: pq_recvbuf: unexpected EOF