Wrong formated date on the first day of the Daylight Saving time.

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Wrong formated date on the first day of the Daylight Saving time.
Дата
Msg-id 200103270935.f2R9ZBb91168@hub.org
обсуждение исходный текст
Ответы Re: Wrong formated date on the first day of the Daylight Saving time.  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-bugs
Laurent Faillie (l_faillie@yahoo.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Wrong formated date on the first day of the Daylight Saving time.

Long Description
Hi every body,

I find this problem using the following configuration:
$ uname -a
HP-UX arvipa B.10.20 A 9000/715 2003042439 two-user license
$ gcc -v
gcc version 2.95.2 19991024 (release)

PostGreSQL v 7.0.3

I use PostGreSQL to store some statistics. The weekend we switch from normal time (TZ=MET-1MET) to daylight saving time
(TZ=MET-1METDST),and when i read statistics from this W.E., I saw a dupplicate data. 
In fact the problem was only on the display. Please see the code bellow.

As you can see, 24 Mar 2001 is displayed twice.

Bye

Laurent

Sample Code
scheduling=# select to_char( jour, '<small>Day</small><br>DD Mon YYYY'), jour from backlog where jour>'2001-03-23';
                 to_char                 |    jour
-----------------------------------------+------------
 <small>Saturday </small><br>24 Mar 2001 | 2001-03-24
 <small>Saturday </small><br>24 Mar 2001 | 2001-03-25
 <small>Monday   </small><br>26 Mar 2001 | 2001-03-26
 <small>Tuesday  </small><br>27 Mar 2001 | 2001-03-27
(4 rows)


No file was uploaded with this report

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

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Local Host Security? All users should have passwords optionally...
Следующее
От: Karel Zak
Дата:
Сообщение: Re: Wrong formated date on the first day of the Daylight Saving time.