Skip site navigation (1) Skip section navigation (2)

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

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Wrong formated date on the first day of the Daylight Saving time.
Date: 2001-03-27 09:35:11
Message-ID: 200103270935.f2R9ZBb91168@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Laurent Faillie (l_faillie(at)yahoo(dot)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


Responses

pgsql-bugs by date

Next:From: Karel ZakDate: 2001-03-27 10:35:57
Subject: Re: Wrong formated date on the first day of the Daylight Saving time.
Previous:From: Marcin KowalskiDate: 2001-03-27 09:03:07
Subject: pg_dump potential bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group