[DUG] another set of eyes

[Jeremy Coulter]

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-bounces at delphi.org.nz [mailto:delphi-bounces at 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

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