Open
Description
Failing ANSI SQL
SELECT YEAR(PAYMENTARRIVETIME) AS YEAR, MONTH(PAYMENTARRIVETIME) AS MONTH, SUM(CAST(QUANTITY AS INT)) AS QUANTITY, SUM(CAST(YOURNETPROFIT AS DECIMAL(10,3))) AS YOURNETPROFIT FROM import
GROUP BY YEAR(PAYMENTARRIVETIME), MONTH(PAYMENTARRIVETIME)
ORDER BY YEAR(PAYMENTARRIVETIME), MONTH(PAYMENTARRIVETIME);
Description
The YEAR function is not recognized