[BUGS] data forma error in pgsql 7.1

2003-10-17 Thread Ivan E. Rivera Uria
We are developing a Vehicle Control Application for Mexico Government (Morelia, Michoacan), and we have a problem with the date format in the database. The Operating System is RedHat Linux 7.2 and database is PostgreSQL Ver. 7.1.3. Explanation: The comand that we execute is: insert into docs

Re: [BUGS] data forma error in pgsql 7.1

2003-10-17 Thread Tom Lane
"Ivan E. Rivera Uria" <[EMAIL PROTECTED]> writes: > the date format that we use is DD/MM/ but whet we execute a select > command we get this information: Sounds to me like you haven't told the database what format you're using. See the DATESTYLE parameter; you need to select "european" forma