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') asdate,
       CaseMin(Date_Time) 
         WhenMax(Date_Time) 
          Then''Else DATE_FORMAT(Date_Time, '%H:%i:%s') 
       Endas InTime,

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