Re: data forma error in pgsql 7.1
"Ivan E. Rivera Uria" <irivera@bnchq.com.mx> writes:
the date format that we use is DD/MM/YYYY 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"
format to get it to default to dd-before-mm date order.
We need to know if is necessary to install some patch to fix this
problem or upgrade the database.
An upgrade would be a good idea in any case. 7.1.3 is pretty old.
regards, tom lane
Import Notes
Reply to msg id not found: 3F9044F5.2080207@bnchq.com.mxReference msg id not found: 3F9044F5.2080207@bnchq.com.mx
Tom you right!!
We only set PGDATESTYLE on root env and then restart the httpd
thanks
Tom Lane wrote:
"Ivan E. Rivera Uria" <irivera@bnchq.com.mx> writes:
the date format that we use is DD/MM/YYYY 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"
format to get it to default to dd-before-mm date order.We need to know if is necessary to install some patch to fix this
problem or upgrade the database.An upgrade would be a good idea in any case. 7.1.3 is pretty old.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
--
===============================================
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
==============================================