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 '09 at 02:20 PM
Dec 18 '09 at 02:49 AM
Dec 16 '09 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 '09 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
asked: Dec 16 '09 at 02:20 PM
Seen: 584 times
Last Updated: Dec 18 '09 at 02:49 AM
Can I use JOIN to qualify rows for a DELETE? The "S" in "SQL" isn't for "Standard," is it?
How can we pass hints to the SQL processor?
What is a co-related sub-query and how it is different from nested queries ?
Heavy MDX Query
Difference between case and code statements in oracle?
Revoking of privileges to one of the users in the below structure will resultant to ?
Oracle SQL Developer 2.1 beta
sql history list
Oracle Rdb Database - Connection Time Out Error
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.