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 Sql > "TZ"/"tz" not s...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 3536 of 3799
Post > Topic >>

"TZ"/"tz" not sup****ted

by maxottovonstirlitz@[EMAIL PROTECTED] ("Peter Kovacs") Jun 20, 2008 at 07:51 AM

Hi,

Execution of the following statement aborts with the error message in
the Subject:

select to_timestamp('2008-06-20 02:30:00 GMT', 'YYYY-MM-DD HH24:MI:SS
TZ');

Does this message mean that this particular PostgreSQL installation
doesn't sup****t timezones?

--------------
select * from pg_catalog.pg_timezone_abbrevs where abbrev = 'GMT';

 abbrev | utc_offset | is_dst
--------+------------+--------
 GMT    | 00:00:00   | f
(1 row)
--------------

The database version is 8.3.0.

Any help appreciated,
Peter

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




 5 Posts in Topic:
"TZ"/"tz" not supported
maxottovonstirlitz@[EMAIL  2008-06-20 07:51:50 
Re: "TZ"/"tz" not supported
andreas.kretschmer@[EMAIL  2008-06-20 08:15:18 
Re: "TZ"/"tz" not supported
andreas.kretschmer@[EMAIL  2008-06-20 08:50:21 
Re: "TZ"/"tz" not supported
tgl@[EMAIL PROTECTED] (T  2008-06-20 10:02:14 
Re: "TZ"/"tz" not supported
scott.marlowe@[EMAIL PROT  2008-06-20 10:22:23 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Tue Dec 2 21:48:30 CST 2008.