Tagged Questions
0
votes
1answer
903 views
MySQL: Why is DATEDIFF and TIMEDIFF/60.0/60.0/24.0 results different?
I have a database with two DATETIME values, and then I generate some new values from them:
tdiff = timediff(d1,d2)+0
day1 = truncate(tdiff/60.0/60.0/24.0,0)
day2 = datediff(d1,d2)+0
All three of ...
