FUNCTION ERROR: Input text cannot be formatted to date Details Invalid format: "2019-03-28" is malformed at "-03-28" Input text 2019-03-28 SqlOperatorImpl PROJECT Location 1:0:3 SqlOperatorImpl PROJECT Location 1:0:3 Fragment 1:0
Not sure what the issue is. This should be super simple.
TO_DATE converts text to a date and the argument should be the format to use when parsing the text. In your case it looks like the text is of format YYYY-MM-DD.