Re: date format and postgreSQL...
| From: | Brinzoi Constantin Aurelian | Date: | Fri, 10 Nov 2000 08:50:07 +0000 |
| Subject: | Re: date format and postgreSQL... | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-4352@lists.php.net to get a copy of this message | ||
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@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"
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>