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: 1417 times
Last Updated: Dec 18, 2009 at 02:49 AM
How do I use a column separated filed within in clause
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 qyery to accept varianles and perform search
sql history list
Compare millions of records from Oracle to SQL server
What is implicit cursor and how is it used by Oracle ?