'NOW' in UTC with no timezone
От | Stuart Bishop |
---|---|
Тема | 'NOW' in UTC with no timezone |
Дата | |
Msg-id | 416B65D4.7020402@stuartbishop.net обсуждение исходный текст |
Ответы |
Re: 'NOW' in UTC with no timezone
|
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi. I'm trying to determine the best way of saying 'The current time in UTC with no time zone information'. I'm currently using CURRENT_TIMESTAMP AT TIME ZONE 'UTC' and inserting into columns defined as TIMESTAMP WITHOUT TIME ZONE which appears to work. However, PostgreSQL parses this into the much more confusing "timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone)" which is what is appearing on my generated documentation. Is there any magic string like 'NOW'::timestamp or CURRENT_TIMESTAMP which returns UTC time? - -- Stuart Bishop <stuart@stuartbishop.net> http://www.stuartbishop.net/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBa2XUAfqZj7rGN0oRAkLJAJ9vOWl1hDSbubKQUnCSvBZg8nzvwACdFjvV 9vACiPZyhnXjlLZuTbGoUrs= =gEL/ -----END PGP SIGNATURE-----
В списке pgsql-general по дате отправления: