Converting a where clause from TSQL to PLSQL

[rodeomount]

Can someone help me with converting the following where clause in TSQL to PLSQL? I need to pull records where the date (in varchar()) is within the last 2 months.




WHERE (IMS_UDT_TS > convert(varchar(26), DATEADD(mm, - 2, getdate()), 21)) AND (IMS_UDT_TS < convert(varchar(26), getdate(), 21))

I need the date to be converted to a string like the following(YYYY-MM-DD.....etc): 2007-11-18-10.55.37.000000

 

[SQLSister]

I think you would be better off inthe Oracle forum for this.

"NOTHING is more important in a database than integrity." ESquared

 

[rodeomount]

I posted it there as well