Re: DATE field formatting in SQL

From: MarkyG <markg_at_mymail.tm>
Date: 20 Jun 2001 01:26:52 -0700
Message-ID: <ab87195e.0106200026.7271e4b1@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 - 03:26:52 CDT