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

And if your sharp, it will not be this wonderful human being. Hey Mogan?

DA Morgan wrote:

> Intikhab Bashir wrote:
>
> > 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
>
> You can either pay someone's hourly consulting rate to do your job for
> you ... or go to http://tahiti.oracle.com and study Oracle.
>
> Your code bears no relationship to anything in Oracle so you have a lot
> of study to do.
>
> Daniel Morgan
Received on Tue Apr 08 2003 - 16:56:02 CDT