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

Do we also need to modify `compareTo` from `TimestampType`