I want Query in PHP Mysql.
I want to get result like if session_Date is same then it shows like 2021-04-02 only one time and session_start time will be first time means 09:30 and last time means 12:30
that means session_date will display only one time and times will display start time and end time.
so I want below formate
session_date | session_start_time | session_end_time 2021-04-02 | 09:30 | 12:30 2021-04-03 | 09:30 | 10:30
thank you in advance.
You could try:
SELECT session_date, MIN(session_start_time), MAX(session_end_time) FROM session GROUP BY session_date
For your case, you could do the following:
SELECT session_date, TIME_FORMAT(MIN(STR_TO_DATE(session_start_time, '%h:%i %p')), '%h:%i %p'), TIME_FORMAT(MAX(STR_TO_DATE(session_end_time, '%h:%i %p')), '%h:%i %p') FROM session GROUP BY session_date;
But I would suggest you store date and time in fields with the respective types, that is