[jira] [Commented] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14990300#comment-14990300 ] Victoria Markman commented on DRILL-4021: - You are correct ! Now I can proudly say 'yes' to the

[jira] [Commented] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-04 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14989734#comment-14989734 ] Julian Hyde commented on DRILL-4021: For the record, and your table 7 notwithstanding, SQL-2011 only

[jira] [Commented] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-04 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14990155#comment-14990155 ] Julian Hyde commented on DRILL-4021: That list does not include {{ }} Why? Because a {{datetime -

[jira] [Commented] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-03 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14988403#comment-14988403 ] Julian Hyde commented on DRILL-4021: I'll ask a rhetorical question: If you subtract two timestamps,

[jira] [Commented] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-03 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14988604#comment-14988604 ] Victoria Markman commented on DRILL-4021: - Julian, We need to remove addition from the title, it

[jira] [Commented] (DRILL-4021) Cannot subract or add between two timestamps

2015-11-03 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14988593#comment-14988593 ] Krystal commented on DRILL-4021: I tried this and got the same error: select cast((cast('2004-05-01