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
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: 
unsubscribe

Reply via email to