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 Admin > Re: Problem wit...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 4935 of 5130
Post > Topic >>

Re: Problem with SGT (Singa****e) timezone

by tgl@[EMAIL PROTECTED] (Tom Lane) Apr 24, 2008 at 11:30 AM

Abhishek Mishra <abhishek.mishra@[EMAIL PROTECTED]
> writes:
> I am using postgresql version 8.1.2. On using the SGT time zone on my
> machine, I get following error:

> ERROR:
> invalid input syntax for type timestamp: "Tue Jan 15 04:09:43.729011
> 2008 SGT"

8.1 has a hard-wired list of timezone abbreviations, and "SGT" isn't in
it.

In 8.2 and later the list of abbreviations is configurable, see
timezone_abbreviations.

			regards, tom lane

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




 1 Posts in Topic:
Re: Problem with SGT (Singa****e) timezone
tgl@[EMAIL PROTECTED] (T  2008-04-24 11:30:25 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan13V112 Tue Jul 8 23:09:07 CDT 2008.