Update on this problem: it only happens if you use the "view data" option.
On the SQL window if you do a "select * from table" the date fields show correctly according to the datestyle set on the host database
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
Thank you
Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars.