Hi,
does someone has an idea, how to get END_DATE / START_DATE where
TO_DATE('06/1/2010','MM/DD/YYYY') ?
SELECT "PROJECT"."ID",
"PROJECT"."CLIENT",
"PROJECT"."NAME",
"PROJECT"."STATE",
"PROJECT"."EARLIEST_START",
"PROJECT"."LATEST_END",
"PROJECT"."EFFORT",
"PROJECT"."LINK",
"PROJECT"."STATUS",
"PROJECT"."DESCRIPTION",
(SELECT SUM((END_DATE - START_DATE + 1) * (WORKLOAD / 100))
FROM WORKITEM WHERE PROJECT = PROJECT.ID
) AS "P_A",
(SELECT COUNT(*)
FROM PUBLIC_HOLIDAY
WHERE HOLIDAY_DATE BETWEEN TO_DATE('06/1/2010','MM/DD/YYYY') AND
TO_DATE('06/2/2010','MM/DD/YYYY')) AS P_B,
"PROJECT_STATE"."STATE",
"PERSON"."DISPLAY_NAME" AS "RESPONSIBLE"
FROM "PROJECT"
INNER JOIN "PROJECT_STATE" ON PROJECT.STATE = PROJECT_STATE.ID
INNER JOIN "PERSON" ON RESPONSIBLE = PERSON.ID WHERE (PROJECT.CLIENT = '1') AND (PROJECT.STATE = 1) ORDER BY "PROJECT"."NAME" ASC