Help me to convert sql query into oracle

Question

Hi I am not aware about oracle So please help me to convert below mentioned sql quesry into oracle

select CONTACT_COMPANY, INTERNET_E_MAIL, cast(case when datediff(yy,CAST('07/07/2011' as datetime),GETDATE())>1 then DATEADD(YY,-1,GETDATE()) else '07/07/2011'  end as datetime),Description as summary,Incident_Number ,Status, status_reason,DATEADD(SS,Submit_Date, DATEADD(mi,-(-360),'01-01-1970 00:00')) Submit_date from ARADMIN.HPD_HELP_DESK where Login_ID='[e-mail]' and upper(Contact_Company) = 'HONDA' and Status=5 and  cast(DATEADD(SS,Submit_Date, DATEADD(mi,-(-360),'01-01-1970 00:00')) as datetime)>=cast(case when datediff(yy,CAST('07/07/2011' as datetime),GETDATE())>1 then DATEADD(YY,-1,GETDATE()) else '07/07/2011'  end as datetime)

Thanks

Manoj

Answer 1

Hi

I think you will be better of asking this question on Oracle forum

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Agreed: This is a SQL Sever forum, not an Oracle forum; please submit your question at an Oracle forum.

(locking the thread)