Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Comparison of Oracle commans Vs. SQL Server Commands

Re: Comparison of Oracle commans Vs. SQL Server Commands

From: EscVector <Junk_at_webthere.com>
Date: 24 May 2007 12:17:00 -0700
Message-ID: <1180034220.440637.204550@q66g2000hsg.googlegroups.com>


On May 23, 1:02 am, Geri Reshef <GeriRes..._at_gmail.com> wrote:
> Where can I find a short comparision of SQL comands of both products?
> I need to find the Oracle equivalents of some SQL Server commands
> (e.g. date functions).

There's no DATEDIFF in Oracle. But you can create a function that equates.
http://msdn2.microsoft.com/en-us/library/aa258269(SQL.80).aspx

http://asktom.oracle.com/tkyte/Misc/DateDiff.html Received on Thu May 24 2007 - 14:17:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US