Bugs in to_char function
От | Tom Rogers |
---|---|
Тема | Bugs in to_char function |
Дата | |
Msg-id | NDBBIAKKEKMAJKGJNMINIEENCEAA.trogers3@creigh.com обсуждение исходный текст |
Ответы |
Re: Bugs in to_char function
Re: Bugs in to_char function |
Список | pgsql-bugs |
I wanted to include the following in a select statement: to_char(departtime, 'HH12:MI PM') as xdepart This gives the correct meridian value for all AM times but incorrectly returns an AM meridian for PM times between 12:00 PM and 1:50:59 PM. If I create the formatted Hours using 'HH24', the displayed 24 hour clock time is correct. I am using PostgreSQL version 7.0.2 on a RedHat Linux 6.2. This is not a super critical problem for me because in this application it's actually more correct for me to be using the 24 hour clock anyway, but I just thought you might want to know about it. I would like to know though, whether this is legitimate and I hope I'm not trying to do this incorrectly. Thank you Tom Rogers
В списке pgsql-bugs по дате отправления: