Forum Replies Created

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

  • Reply To: Second Friday of every month

    This was removed by the editor as SPAM

    July 30, 2022 at 11:31 am

    #4070328

  • 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),...

    • This reply was modified 3 years, 3 months ago by  lokesh97singh.

    September 21, 2021 at 3:51 pm

    #3931536

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