[SPARK-3407][SQL]Add Date type support

OK... verified this behavior with Hive, I've no idea about this :(