Jump to content
Sign in to follow this  
joesoaper

Using SELECT SEC_TO_TIME on 2 fields

Recommended Posts

Follow on posting to my previous post... had to take a totally new approach hence the new posting. As always any help or advice on how to find a solution is greatly appreciated.

 

 

I am trying to sum the total number of hours worked from 2 different fields - overtime_hours and overtime_hours1. I can get the code to run when only getting the information from one field, but am failing to get the same success when attempting to get it from 2 fields.

 

Here is the working code for one field.

$count_total_hours_worked = $pdo->query("SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( `overtime_hours` ) ) )FROM dbase WHERE staff='Joe'  AND MONTH(CURDATE())=MONTH(serv_date) AND YEAR(serv_date) = YEAR(CURDATE()) ")->fetchColumn();     
                      

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  



×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.