[Enhancement] Reduce varchar cast inside date/datetime cast (backport #56318)

[Enhancement] Reduce varchar cast inside date/datetime cast (backport #56318) #30076