Re: How to change default date format for my application

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sun, 26 Sep 2004 16:06:04 GMT
Message-ID: <LNB5d.373142$8_6.367807@attbi_s04>

"Axel Seinsche" <newsgroup_at_seinsche.net> wrote in message news:4156cec2$0$25785$9b622d9e_at_news.freenet.de...
> Hi all,
>
> I am using Oracle DB's from 8.1.7 to 10.1 and have a general problem.
> How can I set the default date format so that the time part will be
> displayed to in my Java application or my JSP pages.
>
> I already tried to set the NLS_DATE_FORMAT env variable, but with this
> the fields are only displayed correctly in sqlplus, but not in my SQL
> client or my JSP pages. I hope someone has a hint for me.
>
> TIA,
> Axel

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 Received on Sun Sep 26 2004 - 11:06:04 CDT