[SPARK-43485][SQL] Fix the error message for the unit argument of the datetime add/diff functions

[SPARK-43485][SQL] Fix the error message for the unit argument of the datetime add/diff functions #43264