From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | l_faillie(at)yahoo(dot)com, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Wrong formated date on the first day of the Daylight Saving time. |
Date: | 2001-03-27 10:35:57 |
Message-ID: | 20010327123557.B27797@ara.zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Mar 27, 2001 at 04:35:11AM -0500, pgsql-bugs(at)postgresql(dot)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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
From | Date | Subject | |
---|---|---|---|
Next Message | Cid R Andrade | 2001-03-27 14:43:32 | Bug about 'Foreign Key' |
Previous Message | pgsql-bugs | 2001-03-27 09:35:11 | Wrong formated date on the first day of the Daylight Saving time. |