Home » SQL & PL/SQL » SQL & PL/SQL » how to get the time from date field
how to get the time from date field [message #245959] Tue, 19 June 2007 07:23 Go to next message
Messages: 72
Registered: May 2005
Location: CHENNAI
Hai Friends,

I want to get the time from the date field.

created date 6/18/2007 1:27:09 PM

i want like this 13:27:09

Re: how to get the time from date field [message #245964 is a reply to message #245959] Tue, 19 June 2007 07:30 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select to_char(sysdate,'HH24:MI:SS') from dual;

1 row selected.

Previous Topic: supplied Packages
Next Topic: ORA-01940: cannot drop a user that is currently connected
Goto Forum:

Current Time: Wed Oct 26 12:50:14 CDT 2016

Total time taken to generate the page: 0.07382 seconds