FF2.12 and SQL select TDATE

[Eivind Bakkestuen [TPX]]

SQL standard for date literal is: DATE 'yyyy-mm-dd'

Yes, for a param use param.AsDateTime := <your date here>.

--

Eivind Bakkestuen [TPX]

Please, no private email unless requested.
This newsgroup is searchable at http://www.tamaracka.com
Visit TurboPower's new Foundry at http://community.turbopower.com

"eric" <er...@kundl.org> wrote in message
news:mvqhRers...@tpsmail01.turbopower.net...
> Delphi 5, XPhome, FF2.12.
>
> i have a table with a field that is a SysTools Date.
>
> what is the syntax for an SQL that selects using the date field, both with
a
> literal and a parm?
>
> ie: select * from Assignments where SchoolDate >= ????
>
> to use a literal, what do i put in the ????. in Oracle, i had to use a
mask
> and a date, but i'm thinking FF is going to be different. the
documentation
> in the syntax for Select looks like it is telling me to do use
> DATE'10/20/2002', but i'm having trouble making sense of the syntax
> definition.
>
> and for a 'parm' i guess i just use a variable that is of TDateTime?
>
> --
> thanks,
> eric kundl
> http://www.kundl.org
>
>

[eric]