>>>> 2012/03/16 13:30 -0400, Simon Wilkinson >>>>
My query for this is as follows: select * from table where table.date1 -
table.date2 between 28425600 and 29030400;
I would not count on that subtraction s yielding a meaningful number: the types are not
Unix timestamps. I would use TIMESTAMPDIFF, with a good unit.
From the downloaded help file:
Date arithmetic also can be performed using INTERVAL together with the
date + INTERVAL expr unit
date - INTERVAL expr unit
but subtracting timestamp from timestamp hoping for a while (interval) is not mentioned.
If you want the subtraction to work, make them big integers and use UNIX_TIMESTAMP and