Date subtraction in embedded SQL

Tags:
AS/400
RPG
SQL

I am trying to get all records with an order date in the past 30 days, but the database field is YYYYMMDD. I know how to do this in RPG, but I really want to do it in embedded SQL. Thanks!

1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Never mind! I found an answer:

 DEC(REPLACE(CHAR(CURRENT_DATE – 30 DAY, ISO), ‘-‘, ”),8,0) 

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: