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
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: 1253 times
Last Updated: Dec 18, 2009 at 02:49 AM
Where are the dollars? Oracle or Sql Server?
System Change Numbers (SCN) on 9i, 10g
Differences between TRUNCATE and DELETE for a table ?
Convert Script from Oracle to SQL
How can we pass hints to the SQL processor?
Revoking of privileges to one of the users in the below structure will resultant to ?
What is a co-related sub-query and how it is different from nested queries ?
batch which will modify the child table if any record is updated in its parent table.
Difference between case and code statements in oracle?
Oracle to SQL