date help 1

[gtb12314]

Hi there,

Please help me out, I want to know what will be the code in oracle 9i for the following line of code, I tried several ways but not yet solved.

I mean I want to transform the following code into oracle 9i SQL.

dateadd('yyyy',-1,(date(year(datadate)-1,month(datadate),1)))

Any suggestion.

Thanks in advance

 

[hilfy]

This looks to me like you're trying to get the date of the first day of the current month from 2 years ago, correct?

Try this (you may have to tweak for syntax....)

Add_Month(To_Date(to_char(sysdate,'MM')||'/01/'||to_char(sysdate, 'yyyy'), 'MM/dd/yyyy'), -12)

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.