ERROR: date/time field value out of range: “2020-06-0700:00:00”

I am trying to run the Select query(linked server) from SSMS to get the data from PostgreSQL on AWS cloud. My query is running fine in SSMS but as soon as I enter the following line of code

and c.created_date >=concat(to_char(CURRENT_DATE – interval ”7 day”, ”yyyy-mm-dd”),”00:00:00”) :: timestamp

it starts giving me ERROR: date/time field value out of range: “2020-06-0700:00:00”;

created_date field in my PostgreSQL is timestamp without timezone

Which datatype should I chose which is compatible with SQL Server?

Go to Source
Author: amanullah