CREATETIMESPAN

I l @ ve RuBoard

Used to create a date/time value that defines a span of time.

Syntax

 CreateTimeSpan(days, hours, minutes, seconds) 

Parameters

Days: Number of days (between 0-32768)

Hours: Number of hours

Minutes: Number of minutes

Seconds: Number of seconds

Example

 <!--- Cache a query for 30 minutes --->  <cfquery name="productlist" datasource="products"          cachedwithin="#CreateTimeSpan(0,0,30,0)#">   SELECT *   FROM tblProducts </cfquery> 

I l @ ve RuBoard