Allow trailing spaces in cast(varchar as date) (#10077)

Allow trailing spaces in cast(varchar as date) (#10077) #2