Hi,
I have to select elements that are not older than 2 months (=60 days).
The table has a standard DATE column with format (YYYY-MM-DD), called
'date'.
I tried a lot of queries, one of them is following:
SELECT * FROM mytable WHERE date > (SYSDATE()-60);
So basically i'm telling mysql to select elements where the date is
bigger (= older) than the actual system date diminished with 60 days.
But it does't return anything (and yes I have elements newer than 2
months in the table :-)
I suppose something is wrong with the use of SYSDATE. Anyone any
...
Bookmarks