Home » SQL & PL/SQL » SQL & PL/SQL » sqlplus
sqlplus [message #432] Mon, 11 February 2002 23:55 Go to next message
Marc
Messages: 26
Registered: August 1999
Junior Member
I would like to use a date format which includes the hour also. But I have no idea of how to use it.
Re: sqlplus [message #436 is a reply to message #432] Tue, 12 February 2002 01:00 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
see this statement it will give u some idea

select to_char(sysdate,'DD-MON-YYYY HH24:MI') from dual
Previous Topic: IMP-00019: row rejected due to ORACLE error 1
Next Topic: Re: steps after sucessfully created the cursor
Goto Forum:
  


Current Time: Fri Aug 14 09:13:34 CDT 2020