Advertisements
Since Netezza does not have a datediff function, the ‘old school’ of calculating the difference, in days, between dates must be used.
Subtracting Inclusive Dates
To subtract to day and include end date, as a day, in calculation (1 day is added)
select (date(‘2015-12-31’) – date(‘2015-01-01’))+1 as Inclusive_dates
From _v_dual;
Subtracting Non-inclusive dates
To subtract dates non-inclusive simply subtract the dates
select date(‘2015-12-31’) – date(‘2015-01-01’) as Non_Inclusive_dates
From _v_dual;
Example SQL From Graphic
select (date(‘2015-12-31’) – date(‘2015-01-01’))+1 as Inclusive_dates,
date(‘2015-12-31’) – date(‘2015-01-01’) as Non_Inclusive_dates
From _v_dual;
One thought on “Netezza / PureData Date – Difference in Days SQL”