DATETIME Format in 12 Hours

@experts585Oct 24.2011 — #print( date("g:i a", strtotime("13:30:30")) );

http://style-vs-substance.com/programming/convert-24-hour-military-time-to-12-hour-ampm-time-in-php/

@newphpcoderauthorOct 24.2011 — #I upload .xml using php and it saves to database.

I tried this data to upload:

100603 10/1/11 5:35 AM 10/1/11 1:35 PM // this is the exact schedule of employee and its 8 hours per day he time in exactly and timeout exactly also, so no problem in computing because it is 8 hours.

100603 10/2/11 5:25 AM 10/2/11 1:55 PM //in this example data the employee time in early in his schedule and time out late.

100603 10/3/11 5:40 AM 10/3/11 1:40 PM // in this example data the employee time in is late, so even he also late to timeout theres no exemption because he late on his work.

and it saves it database:

100603 2011-10-01 05:35:00 2011-10-01 13:35:00

100603 2011-10-02 05:25:00 2011-10-01 13:55:00

100603 2011-10-02 05:40:00 2011-10-01 13:40:00

Now, I know that the data stored time in database formatted in 24 hours. Honestly, I want to accomplish is to get the total hours of the employee based on the employee no.

and I tried this code:

<i>
 </i>select  sec_to_time(unix_timestamp(timeout) - unix_timestamp(timein)) AS totalhours from employee;

and the result of this code is:

totalhours:

08:00:00

08:30:00

08:00:00

and the result is

the first is correct because the real schedule is 5:35 AM - 1:35 PM

the second is wrong it should be 8 hours only even he timein early and timeout late.

the third is also wrong because the employee is late to timein, even he also timeout late., it should be deduct or subtract in hours the late of employee.

@experts585Oct 24.2011 — #i think you should try if else conditions for this metter

@newphpcoderauthorOct 24.2011 — #How???can you give me an idea or example?I only do this internally...I mean I only run the query in database.

Thank you

DATETIME Format in 12 Hours

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

DATETIME Format in 12 Hours

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴