Horton
Menu

Thread

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

    PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-03-27T09:35:11Z

    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

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

    Karel Zak <zakkr@zf.jcu.cz> — 2001-03-27T10:35:57Z

    On Tue, Mar 27, 2001 at 04:35:11AM -0500, pgsql-bugs@postgresql.org wrote:

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

It's common problem with this time in 7.0.x - already fixed in 7.1.

> 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)


 Note: use quotation marks for non-format masks, it is faster. 
En example:

	to_char( jour, '"<small>"Day"</small><br>"DD Mon YYYY')

		Karel

-- 
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz