On May 24, 5:11 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
But some people need functions... :)
Received on Fri May 25 2007 - 13:03:16 CDT
