IT Web Feeds » Ben Nadel ColdFusion And Web Development Feed @ BenNadel.com » Using MySQL's TO_DAYS() Function To Group Same-Day Events

Feeds

4226 items (4226 unread) in 12 feeds

• Developer Fusion Recent Articles & Tutorials (62 unread)

WebDevelopment (3842 unread)

• Open Source Web Development Tutorials - RSS Feeds (170 unread)
• 4GuysFromRolla.com Headlines (7 unread)
• ASP.NET Daily Articles (262 unread)
• SitePoint.com (10 unread)
• ScottGu's Blog (38 unread)
• C-Sharpcorner Latest Articles (2512 unread)
• The Code Project Latest Articles (833 unread)
• Developer Tutorials (10 unread)

PHP (23 unread)

• Good PHP Tutorials - New Tutorials (23 unread)

ColdFusion (191 unread)

• Ben Nadel ColdFusion And Web Development Feed @ BenNadel.com (191 unread)

MicrosoftExchangeServer (108 unread)

• MSExchange.org (108 unread)

Ben Nadel ColdFusion And Web Development Feed @ BenNadel.com

• July 12, 2011
• 

  Using MySQL's TO_DAYS() Function To Group Same-Day Events

  Posted: July 12th, 2011, 10:24am CDT

  The other day, I was creating a reporting and statistics page for a small project. One of the reports that I had to generate required me to group records by Date, outputting the number of records created on each day. The records themselves had a dateCreated field containing a date/time value. Due to the time portion of the date/time value, however, I couldn't group the records directly by their dateCreated value; but, I could group them together based on their calculated TO_DAYS() value. Unfo ... Read More »