DateTime String To Date, In Time And Out Time

I have attendance record table like this +----------------+---------+-----------------------+ | NIP | Nama | Date_Time | +----------------+---------+----

Solution 1:

Here is the SQLFiddel Demo

Below is the Query

select NIP,
       Nama,
       DATE_FORMAT(Date_Time, '%Y-%m-%d') as date,
       Case Min(Date_Time) 
         When Max(Date_Time) 
          Then '' 
         Else DATE_FORMAT(Date_Time, '%H:%i:%s') 
       End as InTime,

       DATE_FORMAT(max(Date_Time), '%H:%i:%s') as OutTime
  from Attd
 Group By NIP,
       Nama,
       DATE_FORMAT(Date_Time, '%Y-%m-%d')