[cfaussie] Grouping Date / time values in a Cfquery output

Hi, I have a table that has duplicate records with columns of date and description and user I have a query that groups all the records by date and the sub groups those records by description which results in those duplicate records that were created on the same date with the same

Re: [cfaussie] Grouping Date / time values in a Cfquery output

sql 2000, 2005 etc set dateformat dmy select from group by convert(datetime, convert(varchar, my_date, 103)), description, user or select from group by year( my_date ), month(my_date), day(my_date), description, user PS. either my email client is showing

Re: [cfaussie] Grouping Date / time values in a Cfquery output

have a look for date/time function available for your database server to format or build out date/time string and group on that 2009/11/23 rai...@ozemail.com.au Hi, I have a table that has duplicate records with columns of date and description and user I have a query that groups all

Re: [cfaussie] Grouping Date / time values in a Cfquery output

Something like this works well in mySQL... cfquery name=pageQuery datasource=#application.dbName# Select count(*) as pageCount, dayOfMonth(activityDate) as dayOfMonth, activityDate from Activity Where activityDate #createODBCDate(startDate)# And