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