Re: date format and postgreSQL...
| From: | Martin A. Marques | Date: | Thu, 09 Nov 2000 22:08:16 +0000 |
| Subject: | Re: date format and postgreSQL... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-24570@lists.php.net to get a copy of this message | ||
On Jue 09 Nov 2000 17:57, Javier Morquecho Morquecho wrote:
> 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"...
Check the locale.
Seems you have some trouble there.
Saludos... ;-)
--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Martín Marqués email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------