I was trying to test the overlap function as mentioned in Vertica
Code: Select all
SELECT (DATE '2007-02-16', DATE '2007-12-21') OVERLAPS (DATE '2008-10-30', DATE '2008-10-30');
-bash: syntax error near unexpected token `DATE'
This is same example as mentioned in Vertica Documentation.
Thanks