Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: AT TIME ZON...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 15979 of 16553
Post > Topic >>

Re: AT TIME ZONE and DST in UTC<->CET conversion

by stark@[EMAIL PROTECTED] (Gregory Stark) Jul 5, 2008 at 01:05 PM

Jarom=C3=ADr Tal=C3=AD=C5=99 <jaromir.talir@[EMAIL PROTECTED]
> writes:

> postgres# select '2008-06-01 10:10:10 UTC' AT TIME ZONE 'CET';
>       timezone=20=20=20=20=20=20
> ---------------------
>  2008-06-01 12:10:10

ISTM this is the one that's wrong. "CET" is standard time, it, GMT+1.

If you want a timezone which switches between CET and CST automatically
you
should use something like Europe/Paris.

--=20
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
tra=
ining!

--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 2 Posts in Topic:
Re: AT TIME ZONE and DST in UTC<->CET conversion
stark@[EMAIL PROTECTED]   2008-07-05 13:05:31 
Re: AT TIME ZONE and DST in UTC<->CET conversion
tgl@[EMAIL PROTECTED] (T  2008-07-05 11:21:36 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Sep 6 22:46:21 CDT 2008.