Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- persisted_date.id_date, org_holiday.org_id, org_holiday.is_holiday, org_holiday.holiday_name, org_holiday.is_easter, org_holiday.is_year_start_mark,
- org_holiday.compensation_shift_for_work, org_holiday.day_in_lieu_for_work, org_holiday.holiday_region,
- persisted_date.YEAR, persisted_date.day_of_week, persisted_date.month_number, persisted_date.is_weekend
- FROM
- org_holiday
- LEFT JOIN
- persisted_date ON org_holiday.id_date = persisted_date.id_date
- WHERE
- org_holiday.is_holiday = 1 AND org_holiday.org_id = {orgId} AND persisted_date.id_date >= {START} AND persisted_date.id_date <= {END}
Add Comment
Please, Sign In to add comment