Re: DATE field formatting in SQL

Er - make that the Osborne texts. Don't know why I get those publishers confused. Sorry.

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:45 CDT