> Is there a way to select the datepart(mydate,"mm/dd/yy") from MSSQL? I can > only seem to return the Day, month or year, but not all three. The field > contains date & time data and I am trying to group on the date part but > the time is throwing off the results.
Concatenation might work. Not sure if it'll work with the grouping: SELECT Month(myDate) + '/' + Day(myDate) + '/' + Year(myDate) FROM myTable Ben Johnson ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
