[BUG] Add concrete exceptions when parsing strings to timestamps in ANSI mode

[res-life]

Describe the bug
Gpu now throws an IllegalArgumentException when parsing strings to timestamps in ANSI mode:

// datetimeExpressions.scala
        // CPU may throw `DateTimeParseException`, `DateTimeException` or `ParseException`
        throw new IllegalArgumentException("Exception occurred when parsing timestamp in ANSI mode")

Spark throws more concrete exceptions:

// in `ToTimestamp` 
            } catch {
              case e: DateTimeParseException if failOnError =>
                throw QueryExecutionErrors.ansiDateTimeParseError(e)
              case e: DateTimeException if failOnError =>
                throw QueryExecutionErrors.ansiDateTimeError(e)
              case e: ParseException if failOnError =>
                throw QueryExecutionErrors.ansiParseError(e)
              case e if isParseError(e) => null
            }

Adding concrete exceptions as Spark does will make the error message more readable.
The priority is low.

It's from: #5316 (comment)