 <p>I found the solution here <a href="http://www.jamesnetherton.com/blog/2008/05/04/Converting-Unix-timestamp-values-in-ColdFusion/" rel="nofollow noreferrer">http://www.jamesnetherton.com/blog/2008/05/04/Converting-Unix-timestamp-values-in-ColdFusion/</a>. I needed to convert the start and end time in order to use in my sql query.</p>