data forma error in pgsql 7.1
От | Ivan E. Rivera Uria |
---|---|
Тема | data forma error in pgsql 7.1 |
Дата | |
Msg-id | 3F9044F5.2080207@bnchq.com.mx обсуждение исходный текст |
Ответы |
Re: data forma error in pgsql 7.1
|
Список | 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@bnchq.com.mx Web: http://www.bnchq.com.mx ==============================================
В списке pgsql-bugs по дате отправления: