In "current_date - 7" the date is converted to a string and than to an Integer.
Use adddate function:
adddate(CURRENT_DATE(),interval -1 day)
Santino
At 11:37 +0100 7-12-2005, christophe nauwelaers wrote:
Hi,
For any reason, current_date doens't look to behave normally since a few
days.
I run r
Hi,
For any reason, current_date doens't look to behave normally since a few
days.
I run reports in a MySQL DB through sql queries and I use a statement like "
... invd between current_date - 7 and current_date - 1 ..." It always
worked.
I just noticed that this week's report was wrong. Indeed : c
