[fpc-pascal]Postgres Query...

[Javier Morquecho Morquecho]

	I get it !!, this is the right sintax is:

query_s := 'select my_date from info where fecha>=''1/1/2000''';

Thanks...!	

Ing. J at vier Morquecho Morquecho
Cedetel
Desarrollo de proyectos comerciales
Tel : 177-10-87
Cel : 177-00-87
e-mail                 : jmorquec at cedetel.com.mx
e-movil               : 5281770087 at emovil.cedetel.com.mx
Home Cedetel     : http://www.cedetel.com.mx

"#define QUESTION ((bb) || !(bb))    // Shakespeare"



-----Mensaje original-----
De: fpc-pascal-admin at deadlock.et.tudelft.nl
[mailto:fpc-pascal-admin at deadlock.et.tudelft.nl]En nombre de Jonas Maebe
Enviado el: Jueves 7 de Diciembre de 2000 12:22 PM
Para: fpc-pascal at deadlock.et.tudelft.nl
Asunto: Re: [fpc-pascal]Postgres Query...


>	I'm making a query to a Postgres database, but I can't use the "where"
>command, I mean, I need to do somethiing like:
>

Shouldn't you put the date between double quotes? And possibly even use 
the data function? I.e.

query_s := 'select my_date from info where fecha>=date("1/1/2000")';


Jonas

_______________________________________________
fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal