Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • Reply To: How show only first friday of every month

    solved!

    1st friday : (SELECT DATEADD(DAY, DECODE(EXTRACT(DOW FROM START_DATE), 0,5, 1,4, 2,3, 3,2 ,4,1, 6,6, 0), START_DATE) third_friday FROM (SELECT date_trunc('month',current_date) START_DATE))

    2nd friday : (SELECT DATEADD(DAY, 7 + DECODE(EXTRACT(DOW FROM START_DATE), 0,5, 1,4,...

    September 21, 2021 at 3:58 pm

    #3931542

  • Reply To: Second Friday of every month

    solved!

    1st friday : (SELECT DATEADD(DAY, DECODE(EXTRACT(DOW FROM START_DATE), 0,5, 1,4, 2,3, 3,2 ,4,1, 6,6, 0), START_DATE) third_friday FROM (SELECT date_trunc('month',current_date) START_DATE))

    2nd friday : (SELECT DATEADD(DAY, 7 + DECODE(EXTRACT(DOW FROM START_DATE),...

    September 21, 2021 at 3:51 pm

    #3931536

Viewing 2 posts - 1 through 3 (of 3 total)