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
Failing ANSI SQL
Description
The YEAR function is not recognized