您可以改用DATE_FORMAT,因為strftime僅在sqlite中使用,因此您可以這樣編輯它 SELECT client_id, COUNT(DISTINCT file_name) AS n_files, status, DATE_FORMAT(received_date, '%M %Y') AS 'month'FROM `Table`WHERE received_date >= '2022-01-01 00:00:00.000000'AND received_date < '2022-09-30 00:00:00.000000'GROUP BY client_id, status, '{{ received_date.strftime("%B %Y") }}'ORDER BY client_id, '{{ received_date.strftime("%B %Y") }}', status