Pls help me to add two times which is in mysql database table....Very urgent...Thank you
ditty
0
Light Poster
Recommended Answers
Jump to Postyou can do it as select it from the mysql side
select time1, time2, addtime(time1,time2) from table
All 2 Replies
dickersonka
104
Veteran Poster
you can do it as select it from the mysql side
select time1, time2, addtime(time1,time2)
from table
Shanti C
106
Posting Virtuoso
You could use DATE_ADD/DATE_SUB such as ADDDATE/SUBDATE and SUBTIME, but that's only available since MySQL 4.1.1.
check this:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.