Re: DATE field formatting in SQL

"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 Wed Jun 20 2001 - 18:09:15 CDT