Good point. When he said timestamp I just assumed he meant datetime. Yeah, if the column truly is a timestamp you are out of luck. Paul is right, they are not a date or a time. Think of them like a newSequentialID().
What is in your viewed_day column? ~Brad -------- Original Message -------- Subject: Re: msql: ordering by date part From: Paul Hastings <[email protected]> Date: Tue, September 29, 2009 9:06 pm To: cf-talk <[email protected]> Mike Little wrote: > 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)? a timestamp in sql server's doesn't have anything to do w/datetime. they are automatically generated binary numbers, unique within a database. yeah a bad name, "rowversion" is a better but less known synonym. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
