[fpc-pascal]Postgres Query...

Javier Morquecho Morquecho jmorquec at cedetel.com.mx
Thu Dec 7 20:08:03 CET 2000

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

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


Ing. J at vier Morquecho Morquecho
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")';


fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org

More information about the fpc-pascal mailing list