backport: fix STR_TO_DATE() Function does not work well

[hustjieke]

Is your feature request related to a problem? Please describe.

previous working issue: #975 commit id: 36279d238ffb8a177f47997795896e92b1704280

Describe the solution you'd like

Describe alternatives you've considered

Additional context