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 > Re: "TZ"/"tz" n...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 5 Topic 3536 of 3702
Post > Topic >>

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

by andreas.kretschmer@[EMAIL PROTECTED] ("A. Kretschmer") Jun 20, 2008 at 08:50 AM

am  Fri, dem 20.06.2008, um  8:35:10 +0200 mailte Peter Kovacs folgendes:
> Thank you, Andreas! Your advice is very useful to me.
> 
> I would still be interested why "TZ" is not accepted in the format
string.

I think because TZ is only useful for displaying a timestamptz and not
for internal representation and/or calculation.

For displaying you can use to_char(timestamptz, format-string).


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

-- 
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 Mon Oct 6 15:41:39 CDT 2008.