Was actually trying to find a way of using DateTime fields in queries.
Just found TIMESTAMP type for CFQueryParam. <CFqueryparam cfsqltype="cf_sql_timestamp" It was the DATE type that was causing the errors in the comparisons. <CFqueryparam cfsqltype="cf_sql_date" ----- Original Message ----- From: "James Holmes" <[email protected]> To: "cf-talk" <[email protected]> Sent: Wednesday, April 15, 2009 2:22 PM Subject: Re: Newbie ... Date / Time formatting > > You can't output a time with dateformat() - you need to use > timeformat() for that bit. > > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com.au/blog/ > > > > 2009/4/15 BobSharp <[email protected]>: >> >> I am having a problem with erroneous MINUTES in my DateTime >> creation/formatting. >> The rest of the DateTime comes out correctly. >>> LINK <<< >> >> <CFset vDate = CreateDateTime(vStartYear,StartMonth,StartDay,00,00,00) /> >> <CFset vStart = DateFormat(vDate, "yyyy-mm-dd HH:mm:ss") /> >> <CFset vDate = CreateDateTime(vEndYear,EndMonth,EndDay,23,59,59) /> >> <CFset vEnd = DateFormat(vDate, "yyyy-mm-dd HH:m > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
