[ https://issues.apache.org/jira/browse/IGNITE-14960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17385333#comment-17385333 ]
Aleksey Plekhanov commented on IGNITE-14960: -------------------------------------------- [~tledkov-gridgain] thanks for the review! Merged to sql-calcite > 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 > Assignee: Aleksey Plekhanov > Priority: Major > Time Spent: 10m > Remaining Estimate: 0h > > 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}} > {{function/timestamp/test_extract.test}} -- This message was sent by Atlassian Jira (v8.3.4#803005)