[FEA] Support to_date with non-UTC timezones without DST

[NVnavkumar]

I wish we can support to_date with CST(China Time Zone) support.

SELECT to_date(col) from xxx;

[NVnavkumar]

@nvliyuan What is the specific string format needed for to_date needed here?

[nvliyuan]

Confirmed in customers query, they only use default format.(yyyy-MM-dd)

[winningsix]

Thanks. Then it's on the list of our supported formats. It's depending on #9997 @razajafri

'yyyy-MM-dd', 'yyyy-MM', 'yyyy/MM/dd', 'yyyy/MM', 'dd/MM/yyyy',  'MM-dd', 'MM/dd', 'dd-MM', 'dd/MM'

[NVnavkumar]

to_date(date_str, fmt) is actually replaced at runtime with cast(gettimestamp(date_str, fmt, TimestampType, Some(<session timezone>), false) as date). So it actually depends on #10035 which might depend on #9997

[NVnavkumar]

Ultimately once the dependency issues are completed, this is just a verification task.

[NVnavkumar]

Basically this requires GpuGetTimestamp work with a non-UTC timezone