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.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
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: 1180 times
Last Updated: Dec 18, 2009 at 02:49 AM
What is implicit cursor and how is it used by Oracle ?
Heavy MDX Query
Where are the dollars? Oracle or Sql Server?
Can I use JOIN to qualify rows for a DELETE? The "S" in "SQL" isn't for "Standard," is it?
Question on outer join.?
Differences between $ORACLE_HOME and $ORACLE_BASE ?
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?