Well I resolved my issue, so I thought I would post it here:

I went back and researched the date formats, and came up with this query:

SELECT REPLACE (convert(varchar, getdate()...

On a similar subject when I run this query...

select cast(DATEPART(yyyy, getdate() - 90) as char(4))+cast(DATEPART(mm, getdate() - 90) as char(2))+cast(DATEPART (dd, getdate() - 90) as char(2))+cast(DATEPART (hh, getdate()) as char(2))+cast(DATEPART...

Would this also apply to Oracle? Sorry, I should have posted that in the beginning of the thread.

Yes, when I pull the data from the history table for the previous 5 weeks, I will need to see the date with a time stamp that is within +/-30...