Re: DATE field formatting in SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Jun 2001 05:57:50 +0200
Message-ID: <tj07m0jvvlu9be@beta-news.demon.nl>

"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
>
>
>

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 Received on Tue Jun 19 2001 - 22:57:50 CDT