In DB2 it would be:

Code:
SELECT
  DATE(
    TIMESTAMP('1970-01-01','00.00.00')
    + (millisecondfield/1000) seconds     )
from ...
...