data forma error in pgsql 7.1

From: "Ivan E(dot) Rivera Uria" <irivera(at)bnchq(dot)com(dot)mx>
To: pgsql-bugs(at)postgresql(dot)org
Subject: data forma error in pgsql 7.1
Date: 2003-10-17 19:37:25
Message-ID: 3F9044F5.2080207@bnchq.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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_requeridos values
(243,5,15,1234567777,'01/11/2004','ivan',1);

the date format that we use is DD/MM/YYYY but whet we execute a select
command we get this information:

id |status|id2|serie |date_exe |f_name |l_name
-------------------------------------------------------------------
243 | 5| 15|1234567777| 2004-01-11 00:00:00-06 | ivan|1

Day and month are interchanged and this error happend only when the day
is less than 12, another error that occure is the year, in some cases
the year is inserted in this way, if the year is 2003, postgresql
inserts it like 0003.

We tested it with the to_char() function, but we have the same error in
the database.

Do you have some information about this problem???

We need to know if is necessary to install some patch to fix this
problem or upgrade the database.

regards

--
===============================================
Ivan E. Rivera Uria
BNC - Systems FPS Manager
Tel. +(52)-55-2614-0510
Fax. +(52)-55-
Email: irivera(at)bnchq(dot)com(dot)mx
Web: http://www.bnchq.com.mx
==============================================

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message elein 2003-10-18 18:20:57 7.3 interval casting broken (7.4 OK)
Previous Message Tom Lane 2003-10-17 19:05:07 Re: data forma error in pgsql 7.1