| From: | Charl Gerber <charlgerber(at)yahoo(dot)com> |
|---|---|
| To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: postgre 7.3 / JSTL problem |
| Date: | 2005-03-07 20:21:53 |
| Message-ID: | 20050307202153.35235.qmail@web41208.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I tried not setting a timezone and then doing:
SET TIME ZONE 'Europe/Amsterdam'
In both cases the JSTL <fmt:formatDate did not work. I
might have to try with no timezone settings in the
code.
In the second case, after setting the timezone, it
showed the time 7 hours too early.... hmmm. weird.
--- Oliver Jowett <oliver(at)opencloud(dot)com> wrote:
> Charl Gerber wrote:
>
> > I have database timestamp fields which are defined
> as
> > "DEFAULT now()".
>
> timestamp with timezone or timestamp without
> timezone?
>
> > Any ideas? A bug in the driver? JSTL settings? The
> > server? My code? :)
>
> It's pretty much impossible to say unless you can
> narrow this down to
> some test code that we can try (ideally, code that
> talks JDBC directly).
>
> -O
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2005-03-07 20:27:01 | Re: [BUGS] BUG #1523: precision column value returned from |
| Previous Message | Charl Gerber | 2005-03-07 20:07:28 | Re: Convert java.sql.Date to java.util.Date |