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

Question

How do i find employee who are hired 6 weeks ago from current running weeks?

My current code executes a query in access DB and filters the data based on WeekNumber Column given by below query..

IIf(Weekday([HiredDate])=7,[HiredDate],[HiredDate]-Weekday([HiredDate])) AS TrainingStart,
Date()+6-Weekday(Date()) AS EndOfWeek,
DateDiff("ww",[TrainingStart],[EndOfWeek]) AS WeekNumber 

We do not have access db anymore and i need to get the data from Oracle db.

How do I write to get same data in this situation?