I am trying to get all the applications which was updated before 5 business day
I am able to to get all the applications by using the following where clause calculation.
Also, I would like to display the number of day it was last updated.
SELECT A.APP_NUM
FROM Application A,
WHERE
((Dayofyear(CURRENT_DATE) - Dayofyear(cast (A.LAST_UPDATE_TIMESTAMP as DATE))) + 1) - ((Week(CURRENT_DATE) - Week(cast (LAST_UPDATE_TIMESTAMP as DATE))) * 2) - (case when DAYOFWEEK(CURRENT_DATE) > 6 then 1 else 0 end) - (case when DAYOFWEEK(cast (LAST_UPDATE_TIMESTAMP as DATE)) < 2 then 1 else 0 end) >5
asked
04 Mar '14, 11:32
gag
0●1●1●1
accept rate:
0%
This forum is about SAP SQL Anywhere not MySQL - you will probably do better on Stack Overflow or a dedicated MySQL forum.