SELECT columns FROM table WHERE anniversarydate BETWEEN <cfqueryparam cfsqltype="cf_sql_timestamp" value="#start#"> AND <cfqueryparam cfsqltype="cf_sql_timestamp" value="#end#">
? On Feb 7, 2008 7:37 AM, Toby King <[EMAIL PROTECTED]> wrote: > Hi there > > I have in a MySQL Database a field called anniversarydate. > > The field is actually a datetime field. > > In the program I want to select all records between certain dates but I am > struggling to do it - am wondering what the secret is. Basically I have in > the field: > > 2008-01-25 15:08:12 I'm guessing that I somehow have to ignore the time > part of the field. > > Regards > > > Thanks in advance > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
