postgre 7.3 / JSTL problem
От | Charl Gerber |
---|---|
Тема | postgre 7.3 / JSTL problem |
Дата | |
Msg-id | 20050307190745.48833.qmail@web41209.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: postgre 7.3 / JSTL problem
|
Список | pgsql-jdbc |
Hi, I'm using Postgre 7.3.4 with the build 113 JDBC drivers. I am using JSTL (jakarta implementation, 1.0.6) in a web-app running on Tomcat 4.1.30. When I start my application (in a ServletContextListener), I have this statement: Config.set(event.getServletContext(), Config.FMT_TIME_ZONE, Constants.TIMEZONE); Where Constants.TIMEZONE = "Europe/Amsterdam" The server is on New Zealand time, 12 hours ahead of Amsterdam time. I have database timestamp fields which are defined as "DEFAULT now()". When I browse the database with an explorer tool, the timestamp is shown in the New Zealand time, eg "07 Mar 06:00". Local (Amsterdam) time is then 06 Mar 18:00. However, if I try to display the timestamp with JSTL <fmt:formatDate value="${row.msgTime}" pattern="dd MMM HH:mm"/> the time is shown as 07 Mar 12:00. Ie 6 hours before NZ time instread of 12 hours later. Any ideas? A bug in the driver? JSTL settings? The server? My code? :) Thanks
В списке pgsql-jdbc по дате отправления: