Convert code from SQL Server 2000 to SQL Plus for Oracle

From: Intikhab Bashir <intikhab.bashir_at_corporate.ge.com>
Date: 8 Apr 2003 08:49:24 -0700
Message-ID: <83a078a7.0304080749.6320e456@posting.google.com>

Hi, how can I change the following so Oracle SQL can recognise. Thanks in advance:

-------------------DATE------------------------- 

declare @year varchar(4)
set @year = datepart(yy, getdate())

declare @month varchar(2)
set @month = datepart(month, getdate())

if (@month) = '1'
begin
set @month = '12'
set @year = @year -1
end
else
set @month = @month - 1

declare @monthName varchar(3)
declare @day varchar(2)

if @month = '1'
begin
set @day = '31'
set @monthName = 'Jan'
end
else if @month = '3'
begin
set @day = '31'
set @monthName = 'Mar'
end
else if @month = '4'
begin
set @day = '30'
set @monthName = 'Apr'
end
else if @month = '5'
begin
set @day = '31'
set @monthName = 'May'
end
else if @month = '6'
begin
set @day = '30'
set @monthName = 'Jun'
end
else if @month = '7'
begin
set @day = '31'
set @monthName = 'Jul'
end
else if @month = '8'
begin
set @day = '31'
set @monthName = 'Aug'
end
else if @month = '9'
begin
set @day = '30'
set @monthName = 'Sep'
end
else if @month = '10'
begin
set @day = '31'
set @monthName = 'Oct'
end
else if @month = '11'
begin
set @day = '30'
set @monthName = 'Nov'
end
else if @month = '12'
begin
set @day = '31'
set @monthName = 'Dec'
end
else
begin
set @day = '28'
set @monthName = 'Feb'
end

declare @date varchar(20)
set @date = @monthName + ' ' + right(@year, 2)

declare @from varchar(30)
declare @to varchar(30)

set @from = '01 ' + @date
set @to = @day + ' ' + @date

print @from
print @to Received on Tue Apr 08 2003 - 10:49:24 CDT