COQL datetime filtering

COQL datetime filtering

Have module in Sandbox, which I need to fetch with datetime filtering. Using COQL, but having error and I sure did all wright but its not work. What did I wrong

  1. queryMap = Map();
    queryMap.put("select_query","select id,rate from Rates where Partner = " + Partner_ID + " AND Currency_ISO_Code = " + Currency + " AND Created Time = '" + Created_Time + "' ORDER BY Created_Time LIMIT 0,10");
    info "queryMap: " + queryMap;
    seacrchRates = invokeurl
    [
        url :"https://www.zohoapis.ca/crm/v3/coql"
        type :POST
        parameters:queryMap.toString()
        connection:"conn"
    ];
  2. ///////////////////////
  3. queryMap: {"select_query":"select id,rate from Rates where Partner = xxxxxxxxxxxxxxxxx AND Currency_ISO_Code = USD AND Created_Time <= '2024-10-18T12:00:00-04:00' ORDER BY Created_Time LIMIT 0,10"}
  4. ////////////////////////////////
  5. seacrchRates : {"code":"SYNTAX_ERROR","details":{"near":"where"},"message":"error occured while parsing the query","status":"error"}
In Analytics its work