This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Adapted for Netezza sum(distinct case when a12.ORDER_CURRENT_STATUS_CODE
in (‘SHIPPED’) THEN dbods01…days_between( date(a12.ORDERDATE_PDT),
date(pa11.WJXBFS1)) - ((FLOOR(dbods01…days_between
(date(a12.ORDERDATE_PDT), date(pa11.WJXBFS1)) / 7) * 2) + C...