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

intikhab.bashir_at_corporate.ge.com said...
> Hi, how can I change the following so Oracle SQL can recognise.
> Thanks in advance:
>

<snip>
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;

If that's not what your code gets, have a look at date functions in the sql manual at http://docs.oracle.com or http://tahiti.oracle.com.

-- 
/Karsten
DBA > retired > DBA