How do i find employee who are hired 6 weeks ago from curren

Hey try this

In Sql Server:

In Oracle:

v_HiredDate TIMESTAMP(3):='2019-07-26'
SELECT *, DateDiff("WW",TrainingStart,EndOfWeek) AS WeekNumber FROM(
Select CASE(TO_NUMBER(TO_CHAR(v_HiredDate, 'dw'))) WHEN 7 THEN v_HiredDate
ELSE -DATEPART * INTERVAL '1' DD(5)(dw,v_HiredDate) +v_HiredDate END AS TrainingStart,
SYSTIMESTAMP + 6 - TO_NUMBER(TO_CHAR(SYSTIMESTAMP, 'dw')) AS EndOfWeek From dual) AS tblNew