How do i write Group By query for datetime field in mysql

Question

I need to group by only date without time from datetime field in table.What can i do friends?

Here My Table field is,

My Mysql query is,

select *,count(ord_number) as ord from tbl_order_details inner join tbl_users on tbl_users.user_id=tbl_order_details.user_id  where 1=1 group by ord_date order by ord asc

shubham715 · Accepted Answer · 2016-11-05 05:58:39Z

3

You can do it by DATE()

Example -

group by DATE(ord_date)

Try this

select *,count(ord_number) as ord from tbl_order_details inner join tbl_users on tbl_users.user_id=tbl_order_details.user_id  where 1=1 group by DATE(ord_date) order by ord asc

answered Nov 5, 2016 at 5:58

shubham715

3,3001 gold badge20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rajesh Patel · Accepted Answer · 2016-11-05 06:01:05Z

1

use DATE() function

select *,count(ord_number) as ord from tbl_order_details inner join 
tbl_users on tbl_users.user_id=tbl_order_details.user_id  where 1=1 
group by DATE(ord_date) order by ord asc

answered Nov 5, 2016 at 6:01

Rajesh Patel

2,0461 gold badge17 silver badges22 bronze badges

Collectives™ on Stack Overflow

How do i write Group By query for datetime field in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related