Home » SQL & PL/SQL » SQL & PL/SQL » How to get the time from datetime? (11g)
icon5.gif  How to get the time from datetime? [message #568473] Fri, 12 October 2012 02:12 Go to next message
vikashkrburnwal@gmail.com
Messages: 61
Registered: October 2012
Location: Bangalore
Member
Hi sir,

i am using one stored procedure there in one variable value is coming like this: Jan 1 1900 6:00AM

from this i want time how to get the time from that.

thanks
Re: How to get the time from datetime? [message #568475 is a reply to message #568473] Fri, 12 October 2012 02:32 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Do you want output 6:00AM or 6:00?
Re: How to get the time from datetime? [message #568476 is a reply to message #568475] Fri, 12 October 2012 02:33 Go to previous messageGo to next message
vikashkrburnwal@gmail.com
Messages: 61
Registered: October 2012
Location: Bangalore
Member
6:00 ONLY

THANKS
Re: How to get the time from datetime? [message #568477 is a reply to message #568476] Fri, 12 October 2012 02:39 Go to previous message
Michel Cadot
Messages: 58632
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TO_CHAR(mydate,'HH:MI')

Same link than in your previous topic.
You should REALLY read the documentation and improve you instead of ALWAYS being spoonfed.

Regards
Michel
Previous Topic: Data value size exceeding 4000 characters
Next Topic: how to run this query correctly?
Goto Forum:
  


Current Time: Thu Jul 31 05:47:22 CDT 2014

Total time taken to generate the page: 0.16724 seconds