[ https://issues.apache.org/jira/browse/IGNITE-14960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Taras Ledkov updated IGNITE-14960: ---------------------------------- Description: 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) Tests: {{function/date/test_extract.test}} {{function/date/test_extract_edge_cases.test}} was: 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) > 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: Bug > Components: sql > Reporter: Taras Ledkov > Priority: Major > > 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) > Tests: > {{function/date/test_extract.test}} > {{function/date/test_extract_edge_cases.test}} -- This message was sent by Atlassian Jira (v8.3.4#803005)