EscVector wrote:
> 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
You can also use the minus (-) operator.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu May 24 2007 - 16:11:54 CDT
