Re: Comparison of Oracle commans Vs. SQL Server Commands

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 May 2007 06:42:32 -0700
Message-ID: <1179927752.797033.145380@p77g2000hsh.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).

The Oracle single row functions such at sysdate, to_date, add_months, and trunc can be found in the SQL manual.

UT1 > set echo on
UT1 > @t7
UT1 > select
  2    sysdate                                Today
  3   ,add_months(sysdate, -1)                Last_Month
  4   ,sysdate + 1                            Tomorrow

  5 ,to_char(sysdate,'YYYYMMDD HH24:MI:SS') With_Time   6 from dual
  7 /

TODAY LAST_MONT TOMORROW WITH_TIME

--------- --------- --------- -----------------

23-MAY-07 23-APR-07 24-MAY-07 20070523 09:41:53 HTH -- Mark D Powell -- Received on Wed May 23 2007 - 08:42:32 CDT