[DUG] another set of eyes

[John Bird]

myOffice Email MessageAn aside - but to avoid date locale problems which I read about here before I ever did SQL I have always tended to use

where ( END>='2010-02-22'  and END <= '2010-02-26' ) 

instead of

where ( END>=#22 FEB 2010 00.00.00# and END <=#26 FEB 2010 00.00.00# ) 

but in practice I would have passed a parameter as a datetime to avoid such issues...

John
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100131/56a70829/attachment.html