Re: How to change default date format for my application

From: Axel Seinsche <newsgroup_at_seinsche.net>
Date: Sun, 26 Sep 2004 18:42:36 +0200
Message-ID: <4156f0e4$0$18967$9b622d9e@news.freenet.de>

Jim Kennedy schrieb:
> "Axel Seinsche" <newsgroup_at_seinsche.net> wrote in message
> news:4156cec2$0$25785$9b622d9e_at_news.freenet.de...
>
>
>
> A better approach is to explicitly display the date as a string in the
> query. select to_char(mydate,'mm/dd/yy hh24:mi:ss') from ...
> Look up the valid date formats for how you want it displayed.
> Jim
>
>

This is exactly what I want to avoid! I have a JSP page where I want to format the date with fmt:formatDate. The same query should be used on different pages and on these pages the date should be formatted differently. This is why I wanted to avoid this. Now with the default settings only the date is well formatted and time is alway 00:00:00 because it's not returned by Oracle - but is contained in the DB.

Axel Received on Sun Sep 26 2004 - 11:42:36 CDT