Date interval syntax? 1

[petersJazz]

How do you get today - 10 days in SQL on AS/400?

I tried this syntax:

select *
from table
where regdate > current_date - interval '10' days(5);

 

[PruSQLer]

current timestamp - 10 days will get you what you want.

 

[PruSQLer]

Actually, to be completely accurate you should code

date(current timestamp - 10 days )