Tuesday 2 August 2016

Fetch the month and year from date where date datatype is datetime

if you want to fetch the records from the below table
Order(varchar)
Order Date(datetime)
 1502014-09-26 10:36:18
 1500 2014-08-26 09:36:18
 5200 2014-06-26 01:36:18
 352 2014-09-26 22:36:18
 8654 2014-05-26 20:36:18
 2554 2014-09-26 14:36:18
 780 2014-03-26 18:36:18
 1200 2014-09-26 15:36:18
Ques: Find out Total amount and month name of order in the Sep 2015
QUERY: SELECT SUM( total ) , month( date_added ) FROM `order` WHERE month( date_added ) =9
OUTPUT: 
Order
month
 4256   9

No comments:

Post a Comment