Check a date on a DB2 table to see if it falls within the last 24 hours.

[sam1221]

The date is in datetime format. I need to do this check in a SQL join statement, but my results don't appear correct.

SELECT emp_ID, emp_EFF_DT
FROM EMP_EMPLOYEE
left outer join INS_COVERAGE ON emp_ID = ins_ID and
 current time > emp_EFF_DT  and
((current time - 24 hours) < emp_EFF_DT)

[Rabbit]

Probably because the date restriction needs to go in the WHERE clause and not the JOIN clause. But you don't provide enough information for us to diagnose the exact issue.