posted 18 years ago
This feels like more a hack than anything, but...
The problem is that mysql converts dates to numerics when you add or subtract. For example, current_date = 2007-04-20, but (current_date + 0) = 20070420. A solution (hack) for this is to do the following:
Ugly, but it works.
David Madouros<br />SCJP 1.4