This should do it: ORDER BY convert(datetime,convert(varchar(10),viewd_last,101))
~Brad -------- Original Message -------- Subject: msql: ordering by date part From: Mike Little <[email protected]> Date: Tue, September 29, 2009 8:23 pm To: cf-talk <[email protected]> hey guys, i have a column 'viewd_last' that is a timestamp format. is it possible to order my query by this column but only by the 'date' part (so time is negligable)? mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326767 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
