convert integer to time

Question

0.00/5 (No votes)

See more:

hallo everyone,
i have trouble during convert integer become time in mysql.
1.i have 2 rows of data in time format.
row A=01:00:00
row B=01:30:00
after that i convert this two data become integer data type and i add row A and B data.
after i get the result from this two row where the result is 150. i try to convert it back become time data type, but i m stuck in this part. any suggestion from senior are appreciate
thank you very much

anywhere this is my sql Query

SQL

SELECT SUM((MID(Total,1,2) * 60) + MID(Total,4,2)) AS Extra_OT FROM extra_overtime WHERE Emp_ID='001EJ011' AND DATE(AttDate)='2013-10-03' GROUP BY Emp_ID, AttDate;

Posted 9-Dec-13 22:27pm

JOE Heart Under Blade

Updated 10-Dec-13 13:53pm

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesh Raja · Answer 1 · 2013-12-09T23:31:00

Solution 1

Why can't you use the ADDTIME function?

SQL

SELECT ADDTIME('01:00:00','01:30:00') AS Extra_OT

Posted 9-Dec-13 23:31pm

Ganesh Raja

Updated 10-Dec-13 1:39am

v2

Comments

JOE Heart Under Blade 10-Dec-13 19:56pm

sorry sir.. i got what do u mean... actually i want to add data of 2 rows, not column. sorry my mistake. is this condition can use in my case?

Ganesh Raja 10-Dec-13 22:39pm

Can you add some sample data?