Yeah, its a date time param. I just formatted it that way to make it easier to read/understand....well....hopefully J
Jeremy From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On Behalf Of John Bird Sent: Sunday, 31 January 2010 11:34 To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] another set of eyes An 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
