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: Convert code from SQL Server 2000 to SQL Plus for Oracle

Re: Convert code from SQL Server 2000 to SQL Plus for Oracle

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 8 Apr 2003 17:36:34 -0700
Message-ID: <73e20c6c.0304081636.30b1a315@posting.google.com>


Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<MPG.18fca2b522bdc172989722_at_news.la.sbcglobal.net>...

> It's been a while since I did TransactSQL, but I think your code can be
> reduced to:
>
> select to_char(sysdate,'dd-Mon-yyyy'),
> to_char(last_day(sysdate),'dd-Mon-yyyy')
> from dual;
>

LOL! Bingo!!!
Amazing, isn't it?
How's this for the much touted "rich" db development environment?
;)

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Tue Apr 08 2003 - 19:36:34 CDT

Original text of this message

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