I want to convert Swipe_Time into Swipe_Time_In and Swipe_Time_Out based on the values
Swipe_Entry_Type,Swipe_Time,Department,Student,Name
In,2015-07-28 09:00:01 AM,CSE,CB049201,Sumanth
In,2015-07-28 09:00:01 AM,CSE,CB049202,Ramya
Out,2015-07-28 05:08:01 PM,CSE,CB049201,Sumanth
Out,2015-07-28 05:08:01 PM,CSE,CB049202,Ramya
if it is AM then new column as Swipe_Time_In and if it is PM then new column as Swipe_Time_Out
... View more