OraFAQ Forum: SQL & PL/SQL » How to get the time from datetime?

Home » SQL & PL/SQL » SQL & PL/SQL » How to get the time from datetime? (11g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How to get the time from datetime? [message #568473]

Fri, 12 October 2012 02:12

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

Report message to a moderator

Re: How to get the time from datetime? [message #568475 is a reply to message #568473]

Fri, 12 October 2012 02:32

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Do you want output 6:00AM or 6:00?

Report message to a moderator

Re: How to get the time from datetime? [message #568476 is a reply to message #568475]

Fri, 12 October 2012 02:33

vikashkrburnwal@gmail.com
Messages: 61
Registered: October 2012
Location: Bangalore

Member

6:00 ONLY

THANKS

Report message to a moderator

Re: How to get the time from datetime? [message #568477 is a reply to message #568476]

Fri, 12 October 2012 02:39

Michel Cadot
Messages: 54194
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 13:56:28 CDT 2013

Total time taken to generate the page: 0.93787 seconds