Parsing Date

[maccten2000]

Hi

I have a SQL Statement where i want to set the dates to be variable. The format of the dates appears to be timstamp i.e. MM/DD/YYYY HH:MM AM/PM

I am using the code below

database.col1 > = CAST (CAST (CURRENT_DATE - interval '7' DAY AS DATE FORMAT 'DD/MM/YYYY')||' '|| CAST('09:00' AS TIME) AS TIMESTAMP)

It is telling me that i have parsed the date incorrectly
I was wondering if anyone can help me out with this piece of code

I have also used a variation of the code but this tells me the format is incorrect

database.col1 > = CAST (CURRENT_DATE - interval '7' DAY AS DATE FORMAT 'DD/MM/YYYY')||' '|| CAST('09:00' AS TIME) AS TIMESTAMP

Thank you for your help