need sql query output like this |
my table look like
Code: Id time_stamp Code: output should be Code: SELECT date(time_stamp) as time_stamp, need suggestion .
10-06-2018, 02:49 AM
(This post was last modified: 10-06-2018, 02:53 AM by jreklund. Edit Reason: Forgot total count )
This should do it.
Code: SELECT temp_time as time_stamp, SUM(AM) as FN, SUM(PM) as AN, count(temp_time) AS `count` FROM (SELECT DATE_FORMAT(`time_stamp`,'%d-%m-%Y') AS temp_time, DATE_FORMAT(`time_stamp`,'%p') AS AM_PM, IF((SELECT AM_PM)='AM',1,0) AS AM, IF((SELECT AM_PM)='PM',1,0) AS PM FROM `date_time`) AS FAKE_TABLE_NAME GROUP BY time_stamp |
Welcome Guest, Not a member yet? Register Sign In |