Re: DATE field formatting in SQL

From: Martin Schneider <martin_at_tntsoftware.com>
Date: Wed, 20 Jun 2001 08:13:21 -0700
Message-ID: <3b30bda1$1_2@news.pacifier.com>

Marky,
Thank you! Works as advertised.
Martin

"MarkyG" <markg_at_mymail.tm> wrote in message news:ab87195e.0106200026.7271e4b1_at_posting.google.com...
> Try
>
> select
> TO_CHAR(MYDATE, 'DD-MOM-YYYY') DATESTAMP,
> TO_CHAR(MYDATE, 'HH24:MI:SS') TIMESTAMP,
> SERVERNAME,
> MESSAGE
> from
> EVENTS
>
>
> "Martin Schneider" <martin_at_tntsoftware.com> wrote in message
news:<3b2ff3fe_1_at_news.pacifier.com>...
> > Hi,
> > I'm working with 8.1.7.0.0 on W2k, my table has a DATE field, and when I
> >
> > select MYDATE, SERVERNAME, MESSAGE from EVENTS
> >
> > in SQL Plus, I see rows of data. So far so good, yet the date is
displayed
> > as 19-Jun-01.
> > Now I would like to see the time stamp along with the date, but am
having
> > trouble.
> > I've looked at the SQL functions, searched technet.oracle.com, and tried
> >
> > select to_char(DATE), SERVERNAME, MESSAGE from EVENTS
> >
> > but without success. Thank you for any suggestions.
> > Martin
Received on Wed Jun 20 2001 - 10:13:21 CDT