<!--- Create the datetime using the current date and hour --->
<cfset dateHour = createOdbcDatetime(DateFormat(Now(), 'yyyy-mm-dd') & " " & TimeFormat(now(), "hh") & ":00:00") />
<!--- The query including cachedwithin --->
<cfquery name="qry_fruit" datasource="#myDatasource#" cachedwithin="#createTimeSpan(0,1,0,0)#" dbtype="odbc">
SELECT apples
FROM fruitbowl
WHERE expiryDate > <cfqueryparam cfsqltype="cf_sql_timestamp" value="#dateHour#" />
</cfquery>