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 and c.created_date <= concat(to_char(CURRENT_DATE - interval '1 day','yyyy-mm-dd') ,' 23:59:59') ::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?