Taras Ledkov created IGNITE-14960: ------------------------------------- Summary: Calcite engine. EXTRACT(DOW FROM d) returns invalid results Key: IGNITE-14960 URL: https://issues.apache.org/jira/browse/IGNITE-14960 Project: Ignite Issue Type: Improvement Components: sql Reporter: Taras Ledkov
The query {{SELECT EXTRACT(DOW FROM CAST('1993-08-14' AS DATE))}} return *7*. According with documentation: *dow* - The day of the week as Sunday(0) to Saturday(6) -- This message was sent by Atlassian Jira (v8.3.4#803005)