Re: Cant see the time

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 23 Oct 2001 12:10:50 +0100
Message-ID: <3bd5507a$0$234$ed9e5944@reading.news.pipex.net>

or if you know that you always wish to see the full time you can alter the sessions value for nls_date_format

eg

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY HH24:MI'; Session altered.

SQL> SELECT SYSDATE FROM DUAL; SYSDATE

---

23/10/2001 12:14

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:ttajhimffr4572_at_corp.supernews.com...


>

> "Andy" <alarkin77_at_excite.co.uk> wrote in message

> news:a608f020.0110230057.7756f648_at_posting.google.com...

> > Hi,

> >

> > this is probbably a silly questions but when inserting a timestamp

> > into my oracle DB i cannot see the time!!

> >

> > Example:

> >

> > INSERT INTO table_name values(sysdate);

> >

> > SELECT * FROM table_name;

> >

> > column_name (columns_name is type DATE)

> > -----------

> > 23-OCT-01

> >

> > I would expect to see '23-OCT-01 09:09:09'.  Is the time just not

> > displayed or is the time not being inserted into the DB?

> >

> > Thanks in advance.

> > Andy.

>

> The default NLS_DATE_FORMAT is DD-MON-YY

> You need to use an appropiate call to to_char

> with an appropiate format mask like 'dd-mon-rr hh24:mi:ss'

> Time to visit the sql reference manual.

>

> Regards,

>

> Sybrand Bakker

> Senior Oracle DBA

>

>

>

>

Received on Tue Oct 23 2001 - 06:10:50 CDT