OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sqlplus

Mon, 11 February 2002 23:55

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.

Tue, 12 February 2002 01:00

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: Sun Apr 28 04:00:48 CDT 2024