Trunc() funciton is to get date part without time from a date object. Is there any function to get Time part of the date object?
Dec 16, 2009 at 02:20 PM
Dec 18, 2009 at 02:49 AM
Dec 16, 2009 at 02:28 PM
Thanks a lot Andrew! Now I am able to extract time. But I have question, don't we have a function like Trunc() to get time part? Here do we need to use TO_CHAR() ? Thanks once again.
Thank you Andrew.
Sorry - the stuff I wrote about TRUNC() and strings was rubbish... its been a long day. I meant of course TRUNC() and numbers.
You can use extract() function also.
more on this web page
Dec 16, 2009 at 02:34 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Dec 16, 2009 at 02:20 PM
Seen: 1406 times
Last Updated: Dec 18, 2009 at 02:49 AM
from table Retrieving data by months parameters...
Oracle Rdb Database - Connection Time Out Error
Oracle SQL Developer 2.1 beta
Can anyone explain this PL/SQL block Error
sql history list
Compare millions of records from Oracle to SQL server
What is implicit cursor and how is it used by Oracle ?
Heavy MDX Query
how to get number of days from comparing two date's values?