get data from past 5 days

[mistektips]

Hi,
I have to get data from past 5 days from AS400 table.
I tried using this query:

SELECT     *
FROM         TESTSQL.C27AUDIT
WHERE     TESTSQL.C27AUDIT.C0027_DATE >= CURRENT (DATE) - 5

But it gives me an error.
Also, I just wanted to clarify that the C0027_DATE field is a numeric field.
Could someone suggest how should I accomplish this task?
Any help will be appreciated.
Thanks in advance.

 

[flapeyre]

I answered this in thread513-1223347.

Feles mala! Cur cista non uteris? Stramentum novum in ea posui!