Re: [PHP-DB] date format and postgreSQL... From: Brinzoi Constantin Aurelian (aurel <email protected>)
Date: 11/10/00

Hi !

Before SELECT .... you must put:

SET DATESTYLE TO 'European';

For more information please type (under psql) "\h SET"

I hope this will help you !

Bye !

Constantin Brinzoi
Dept. Sondaje
IRECSON

On Thu, 9 Nov 2000, 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"...
>
> What's going on?...
>
> Thanks in advance...
>
> Ing. J <email protected> Morquecho Morquecho
> Cedetel
> Desarrollo de proyectos comerciales
> Tel : 177-10-87
> Cel : 177-00-87
> e-mail : jmorquec <email protected>
> e-movil : 5281770087 <email protected>
> Home Cedetel : http://www.cedetel.com.mx
>
> "#define QUESTION ((bb) || !(bb)) // Shakespeare"
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>