[Backport 2.18] Fix a regression issue of parsing datetime string with custom time format in Span (#3079)

[Backport 2.18] Fix a regression issue of parsing datetime string with custom time format in Span (#3079) #8141