Support `CAST(timestamp_col AT TIME ZONE 'UTC' AS DECIMAL[(<precision>)])`
Open
compatibility-mysql80
type/compatibility
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
To make it easier to get a timestamp column in UTC time zone on the client regardless of `@@time_zone`, we should support `CAST( AT TIMESTAMP '{+00:00|UTC}' AS DATETIME[()])`, which MySQL introduced in 8.0.22
Contributor guide
Assessment
This issue has not been assessed yet.