Thanks Jim....all is OK now! -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 9:27 AM To: CF-Talk Subject: Re: ts date format
Jim Wright wrote: > > <CFQUERY name="get" datasource="bbb _log"> > SELECT * FROM bbb > where timereceived between #createodbcdate(startdate)# and > #createodbcdate(enddate)# > </cfquery> > Seeing Ben's post reminded me that this query will eliminate 3.33 milliseconds of time... where timereceived >= #createodbcdate(startdate)# and timereceived < #createodbcdate(enddate)# should make sure all milliseconds are accounted for. and the monks won't have to find somewhere to put that extra time (Terry Pratchett fans may understand this reference). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
