date format and postgreSQL...

From: Date: Thu, 09 Nov 2000 20:57:05 +0000
Subject: date format and postgreSQL...
References: 1  Groups: php.db php.general 
Request: Send a blank email to php-db+get-4343@lists.php.net to get a copy of this message
Hi... I guess this is a very simple question, but it is drive me creazy (may be I need vacations)... I'm using PostgreSQL, and I have problems to understend date management... I execute the next insert commands... insert into test values ('any1', '2/11/2000') insert into test values ('any1', '2/10/2000') insert into test values ('any1', '20/10/2000') But when I do a select * from test: any|02-11-2000 any|02-10-2000 any|10-20-2000 And, When I'm reading my recorset I have a date with "dd-mm-yyyy" and another date with "mm-dd-yyyy"... What's going on?... Thanks in advance... Ing. J@vier Morquecho Morquecho Cedetel Desarrollo de proyectos comerciales Tel : 177-10-87 Cel : 177-00-87 e-mail : jmorquec@cedetel.com.mx e-movil : 5281770087@emovil.cedetel.com.mx Home Cedetel : http://www.cedetel.com.mx "#define QUESTION ((bb) || !(bb)) // Shakespeare"

« previous php.db (#4343) next »