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

It seems cast('1970-01-01' as date) < cast('1970-01-01 00:00:00' as timestamp)