Re: Inconsistency of timezones in postgresql
| От | Chris BSomething |
|---|---|
| Тема | Re: Inconsistency of timezones in postgresql |
| Дата | |
| Msg-id | CADrHaBE9EykgvqWQnm0wV7eZdzXjS0G+YZNpZxqpqEXXduwQdA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Inconsistency of timezones in postgresql (Aleksander Alekseev <aleksander@timescale.com>) |
| Ответы |
Re: Inconsistency of timezones in postgresql
|
| Список | pgsql-bugs |
"The function timezone(zone, timestamp) is equivalent to the SQL-conforming construct timestamp AT TIME ZONE zone."
Documentation seems to think it is.
On Wed, 31 Jul 2024 at 20:52, Aleksander Alekseev <aleksander@timescale.com> wrote:
Hi,
> I don't think merely thinking of a new function name is good enough because "AT TIME ZONE" I believe is an SQL standard. Now I don't have the SQL standard because I don't want to shell out the crazy money they want for it [...]
From what I can tell AT TIME ZONE syntax is not a part of the SQL
standard. The standard describes only implicit casts between TIMESTAMP
WITH TIMEZONE and TIMESTAMP WITHOUT TIMEZONE.
--
Best regards,
Aleksander Alekseev
В списке pgsql-bugs по дате отправления: