Casting String to Date should throw exception on parse error in ANSI mode

[razajafri]

Currently, when casting a string as timestamp type in ANSI mode, Spark throws a runtime exception on parsing error.
However, the result for casting a string to date is always null. We should throw an exception on parsing error as well.

Additional context
Look at Spark commit for details