I have a bunch of product orders and I'm trying to group by the date and sum the quantity for that date. How can I group by the month/day/year without taking the time part into consideration?
3/8/2010 7:42:00 should be grouped with 3/8/2010 4:15:00
You can use the following SQL Query to do group by date time column:
SELECT count (CAST (my_DateTime AS DATE))FROM dbo.table_nameGROUP BY CAST (my_DateTime AS DATE)
SELECT count (CAST (my_DateTime AS DATE))
GROUP BY CAST (my_DateTime AS DATE)
or you can also use CONVERT instead of CAST like following:
SELECT count (CONVERT(CHAR(8),DateTimeColumn,10))FROM dbo.table_nameGROUP BY CONVERT(CHAR(8),DateTimeColumn,10)
SELECT count (CONVERT(CHAR(8),DateTimeColumn,10))
GROUP BY CONVERT(CHAR(8),DateTimeColumn,10)
I recommend this SQL Certification course if you wish to learn writing SQL queries and check out this SQL tutorial to learn more about CAST and CONVERT functions.
Certification in Digital Marketing |
Certification in Big Data Analytics |
Certification in Cloud & Devops |
Certification in Full Stack Web Development
Big Data and Data Science Master’s Course |
Data Science Architect Master’s Program |
Cloud and DevOps Architect Master’s Course |
Artificial Intelligence Engineer Master’s Course |
Microsoft Azure Certification Master’s Training
Data Science Course Online |
Big Data Hadoop Certification Training |
Machine Learning Course Online |
Artificial Intelligence Course and Training |
Salesforce Certification Training: Administrator and App Builder |
Tableau Training and Certification Course |
Python Data Science Course & Training |
Ethical Hacking Course |
Business Analyst Course |
Courses in Cyber Security
© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.