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:263710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
