abs0lut Posted October 17, 2008 Share Posted October 17, 2008 I have a field name field1 which data type is datetime in database , I want to subtract it from another field2 with same data type. Could you please help me subtract hours? Quote Link to comment https://forums.phpfreaks.com/topic/128783-subtracting-time/ Share on other sites More sharing options...
akitchin Posted October 17, 2008 Share Posted October 17, 2008 it depends on exactly what result you're looking for. have a look at the MySQL manual regarding the different date and time functions: http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html of interest might be DATEDIFF(). Quote Link to comment https://forums.phpfreaks.com/topic/128783-subtracting-time/#findComment-667638 Share on other sites More sharing options...
MadTechie Posted October 17, 2008 Share Posted October 17, 2008 you can't use DATEDIFF() as "Only the date parts of the values are used in the calculation. " i convert to unix time to make my life easier but then again i hate working with dates.. Theirs a few ways.. heres one that will give hour minutes and seconds SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(field1) - UNIX_TIMESTAMP(field2), '%h:%i:%s') as MyTime Quote Link to comment https://forums.phpfreaks.com/topic/128783-subtracting-time/#findComment-667640 Share on other sites More sharing options...
akitchin Posted October 17, 2008 Share Posted October 17, 2008 touche, i didn't see the "hours" part. my mistake. Quote Link to comment https://forums.phpfreaks.com/topic/128783-subtracting-time/#findComment-667642 Share on other sites More sharing options...
PFMaBiSmAd Posted October 17, 2008 Share Posted October 17, 2008 TIMEDIFF() will subtract two datetime values and give the result in time (time greater than 24 hours would need to be converted to days by the application code.) Quote Link to comment https://forums.phpfreaks.com/topic/128783-subtracting-time/#findComment-667645 Share on other sites More sharing options...
MadTechie Posted October 17, 2008 Share Posted October 17, 2008 touche, i didn't see the "hours" part. my mistake. Sorry akitchin, kinda revenge for all those misread i have done and had a mod slam me.. no harm intended lol Quote Link to comment https://forums.phpfreaks.com/topic/128783-subtracting-time/#findComment-667650 Share on other sites More sharing options...
abs0lut Posted October 17, 2008 Author Share Posted October 17, 2008 thank you Quote Link to comment https://forums.phpfreaks.com/topic/128783-subtracting-time/#findComment-667670 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.