[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17681172#comment-17681172 ] Julian Hyde commented on CALCITE-759: - [~mbudiu], Regarding "dialect". The {{SqlDial

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17681171#comment-17681171 ] Julian Hyde commented on CALCITE-759: - [~mbudiu], It seems that you are right. Postg

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17681119#comment-17681119 ] Mihai Budiu commented on CALCITE-759: - I have a related question about the evaluatio

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16810016#comment-16810016 ] Julian Hyde commented on CALCITE-759: - [~Stabmeqt] See the discussion in IMPALA-4018

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792884#comment-16792884 ] Julian Hyde commented on CALCITE-759: - Would you be able to implement Oracle's speci

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792877#comment-16792877 ] Anton Bankovskii commented on CALCITE-759: -- [~julianhyde] I thought about Java

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792862#comment-16792862 ] Julian Hyde commented on CALCITE-759: - [~Stabmeqt] Thanks. I saw you created CALCITE

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16791543#comment-16791543 ] Anton Bankovskii commented on CALCITE-759: -- [~julianhyde], since there are seve

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16499128#comment-16499128 ] Julian Hyde commented on CALCITE-759: - Thanks for doing this analysis. Very useful.

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16499089#comment-16499089 ] Sergey Nuyanzin commented on CALCITE-759: - Ok,  I see there is the initial atte

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16491249#comment-16491249 ] Julian Hyde commented on CALCITE-759: - This is the main thing that has not been done:

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16491234#comment-16491234 ] Sergey Nuyanzin commented on CALCITE-759: - Not fully understand what is wrong wit

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16491186#comment-16491186 ] Julian Hyde commented on CALCITE-759: - I'd like to have the DAYOFWEEK, DAYOFMONTH, DA

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16490251#comment-16490251 ] Sergey Nuyanzin commented on CALCITE-759: - Hello everyone if nobody minds I can p

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15352178#comment-15352178 ] Julian Hyde commented on CALCITE-759: - I agree. TO_TIMESTAMP would be useful. > Add

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15347066#comment-15347066 ] Sergey Likhoman commented on CALCITE-759: - Also useful function to_timestamp (str

[jira] [Commented] (CALCITE-759) Add DayOfWeek and other missing date/time functions

[ https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15178310#comment-15178310 ] Julian Hyde commented on CALCITE-759: - Microsoft SQL Server has CONVERT and DATEDIFF.