Function --- One day Less than Today

[vechalapu]

Hi,

Is there any function I can use to select records one day less than CURRENT_DATE in DB2? I would like to retrive records loaded one day before than that day in a DB2 SQL Query.

Thanks in advance.

 

[stoggers]

Hi,

(CURRENT DATE - 1 DAY) will return the previous date - just use this expression in the predicate of your select statement. eg.

SELECT * FROM table_x WHERE date_column > (CURRENT DATE - 1 DAY)

Regards,

Mike.

 

[vechalapu]

Hi Mike,

Thank You Very Much