I am working asp.net web application with db2 provider with C #

I need this as an example only in DB2

select orderdate
from Orders
where month(orderdate) = month(getdate())-1



If anyone knows please help me Go to the complete details ...