Good day!
I have 2 columns one for timein and one for timeout…and the data is from uploaded .xml file, my problem now is the saving of timeout in database…
in my .xml file I have this data:
Emp no Time In Time Out
100603 10/1/11 7:30 AM 10/1/11 6:00 PM
100603 10/2/11 8:00 AM 10/2/11 6:30 PM
and it saves in db
Emp no Time In Time Out
100603 2011-10-01 07:30:00 2011-10-01 18:00:00
100603 2011-10-02 08:00:00 2011-10-01 18:30:00
I want the timein and time out is formatted in 12 hours. As you can see the time out is formatted in 24 hours.
Thank you…