Query-Oracle-SQL- Get All Monday for the date range
SELECT
to_char(dt, 'mm/dd/yyyy') || '-' ||
to_char(dt + 6, 'mm/dd/yyyy') time_card_datetime
FROM
(
SELECT
TO_DATE(
to_char(:P_FROM_DATE, 'mm/dd/yyyy'), 'mm/dd/yyyy'
) + (LEVEL -1) dt
FROM DUAL CONNECT BY
LEVEL <= TO_DATE (to_char(:P_TO_DATE, 'mm/dd/yyyy'),
'mm/dd/yyyy')
- TO_DATE (to_char(:P_FROM_DATE, 'mm/dd/yyyy'),
'mm/dd/yyyy'
)
) main_tab
WHERE TRIM ( TO_CHAR (dt, 'DAY')) = '1'
No comments:
Post a Comment