Try select cast(x as y) from query order by y
On Sun, Aug 21, 2011 at 8:45 AM, Richard White <[email protected]> wrote: > > Hi > > is there a way to use the cast function in the order by clause, e.g: > > Select x from query > order by cast(x as date) > > it shows an error saying cast cannot be used. Does anyone know a way around > it? > > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
