kbmMemSQL filter using date

[moctes]

Hi,

I couldn’t find a sample of ExecSQL, using a datetime field on the WHERE clause, I’m looking for something like this:

consMT.ExecSQL(‘select myDateField, myTextField from gastos where myDateField >= ‘);

On a Query component I would use parameters and then Params[0].AsDateTime := etc

How can I use dates on the Where clause?

With regards.
Mocte

[moctes]

After posting this I remembered that the Date(Time) type is a number, so for now I solved it like this:

QueryMT.ExecSQL( Format(‘select * from expenses where myDateField >= %d’, [trunc(myDate)]) );

Still if there is a better way to do it tips are welcome

[kimbomadsen]

Hi,

You can use SQL function DATE(col). It will essentially do the same (use trunk)

/Kim

[Author]

Posts