Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Convert code from SQL Server 2000 to SQL Plus for Oracle
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
![]() |
![]() |