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

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

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 (view raw or flat)
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

In response to

pgsql-bugs by date

Next:From: Cid R AndradeDate: 2001-03-27 14:43:32
Subject: Bug about 'Foreign Key'
Previous:From: pgsql-bugsDate: 2001-03-27 09:35:11
Subject: Wrong formated date on the first day of the Daylight Saving time.

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