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:326769 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
