Skip site navigation (1) Skip section navigation (2)

Re: Pgadmin III not honoring DATESTYLE

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Francisco Leovey" <fleovey(at)yahoo(dot)com>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Pgadmin III not honoring DATESTYLE
Date: 2006-01-18 13:05:27
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40103D8CD@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 


________________________________

	From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Francisco
Leovey
	Sent: 18 January 2006 12:01
	To: pgadmin-support(at)postgresql(dot)org
	Subject: [pgadmin-support] Pgadmin III not honoring DATESTYLE
	
	
	PostgreSQL version: 8.1.2
	Operating system:   Linux
	Description:        Pgadmin III not honoring DATESTYLE
	Details: 
	
	By default in postgresql.conf the DATESTYLE is set to
"SQL,European" and it works OK except for Pgadmin III.
	When you ask for "view data" in Pgadmin III a date field shows
yyyy-mm-dd instead of dd/mm/yyyy
	Please tell me how to fix this
	 

pgAdmin works with DATESTYLE=ISO to ensure that dates cannot be
misinterpreted when using servers with different settings. Supporting
differing datestyles on different servers is not easy to do and can lead
to user confusion. As an administration tool we prefer pgAdmin to remain
unambiguous rather than make it easy to unintentionally enter invalid
data, or misinterpret query results.
 
Regards, Dave

Responses

pgadmin-support by date

Next:From: Jim CripeDate: 2006-01-19 00:34:10
Subject: pgAdmin on SUSE 10.0 needing libcrypto.so.5 and libssl.so.5
Previous:From: Francisco LeoveyDate: 2006-01-18 12:01:13
Subject: Pgadmin III not honoring DATESTYLE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group