Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting long dates
Try setting the NLS_DATE_FORMAT for your session with the alter session command.
-- Miles Thomas Logica UK Ltd thomasm "at" logica "dot" com The above are personal opinions, and are not necessarily the opinions of my employer. Jason C Miller <jm+@andrew.cmu.edu> wrote in article <AneVunO00YUu0fuUQ0_at_andrew.cmu.edu>...Received on Sat Jun 21 1997 - 00:00:00 CDT
> I'm trying to get Oracle queries to return long dates format
> (actually, I'm pref'ing to "MM/DD/YY HH24:MI" if possible. Normal
> queries seem to give me just the date. I've tried many combinations
> of "in" and the "to_char" function, but I'm hoping I've missed out on
> a much easier way. Perhaps even a way to make this default for the
> entire database and not just a given query.
>
> I'm using OWS 7.3 and WebServer (WebApp Server if you will) and would
> like to easily be able to query with the long dates. It would be
> extra wonderful if I didn't need to change the included Oracle
> "tablePrint" command to bring up this data (or do some type of view
> select for each table, which is just as ugly IMO).
>
> Thanks in advance,
> Jason
>
>
---------------------------------------------------------------------------- ---
> |\\| Jason Miller |//| jm_at_andrew.cmu.edu VOX
412/862-3576
> |//| Information Systems & Comp Sci |\\| jason_at_halotech.com BIZ
412/361-HALO
> |\\| Carnegie Mellon University |//| FAX
412/361-8399
> In the end we will conserve only what we love, we will love only what
we
> understand, we will understand only what we are taught.
>