[Lazarus] Filtering on date with TDbf

Alexsander Rosa alexsander.rosa at gmail.com
Tue Jan 31 14:09:56 CET 2012


Use QuotedStr and FormatDate for that matter.
sql := 'where datum >= ' + quotedstr ( formatdate ( 'yyyy-mm-dd', now ) );

2012/1/31 Guionardo Furlan <guionardo at gmail.com>

> Exactly!
>
> 2012/1/31 Michael Joyner <mjoyner at vbservices.net>:
> > to be able to compare dates as strings, you should always set the format
> as
> > year-month-day
>
>
>
> --
> Timeo hominem unius libri
> Cogito ergo sum - Carpe diem
>
> []s
> Guionardo Furlan
> http://guionardo.blogspot.com
> http://www.guionardofurlan.com.br
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>



-- 
Atenciosamente,
Alexsander da Rosa
http://rednaxel.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20120131/a1fbe3dd/attachment-0003.html>


More information about the Lazarus mailing list