|
|
|
|
|
|
by irq-1
823 days ago
|
|
|
Looks like `AT TIME ZONE 'UTC'` should not be used, but I don't think it's illegal syntax. https://www.postgresql.org/docs/current/datatype-datetime.ht... > PostgreSQL endeavors to be compatible with the SQL standard definitions for typical usage. However, the SQL standard has an odd mix of date and time types and capabilities... > Although the date type cannot have an associated time zone, the time type can. (emphasis mine) > To address these difficulties, we recommend using date/time types that contain both date and time when using time zones. |
|
|