We only set PGDATESTYLE on root env and then restart the httpd
thanks
Tom Lane wrote:
"Ivan E. Rivera Uria" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] Web: http://www.bnchq.com.mx ==============================================
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
