Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: DATE field formatting in SQL
The Olsen text on plsql seems to cover all the basics pretty well. I've only run across two structure they did not comprehensively explain.
jds.
Martin Schneider wrote:
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tj07m0jvvlu9be_at_beta-news.demon.nl...
> >
> > "Martin Schneider" <martin_at_tntsoftware.com> wrote in message
> > news:3b2ff3fe_1_at_news.pacifier.com...
<snip>
> > > Now I would like to see the time stamp along with the date, but am
having
> > > trouble.
<snip>
> > > Thank you for any suggestions.
> > > Martin
> >
> > select to_char(date, 'dd-mm-yyyy hh24:mi:ss'), servername, message from
> > events
> >
> > Are you serious you couldn't find that in the docs?
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> Sybrand,
>
> Thank you! This was just what I needed. Unfortunately I didn't find (or
> missed) "to_char" in the doc's I searched:
> _Oracle DBA 101_ by Theriault, et. al. Checked index & Ch 11, Tools.
> _Oracle 8i for Windows NT Started Kit_ by Bobrowski. Index.
> SQL *Plus Worksheet app. Help files.
> SQL *Plus. No online help.
> technet.oracle.com On technet, I did find the doc "Oracle8i Lite...SQL
> Reference" Doc #A73270-01, but looked primarily at the Date functions,
> missing the Conversion functions. After reading the section on to_char, it
> appears to be missing some fmt options. Hindsight is 20/20, but I probably
> should have continued digging. Overall I'm wondering if I need to invest in
> a book specific to SQL Plus. Suggestions? Can you recommend other
> introductory Oracle books or learning tools (news groups, web sites, etc.)?
> Thanks,
> Martin
Received on Thu Jun 21 2001 - 21:34:03 CDT