From: "Frank Bax"
> I have a table with datetime field and I would like to select all data
> older than "X" weeks, where "X" is a variable in my php script.
SELECT (.) WHERE `datetime_field` < NOW() - INTERVAL (7*X) DAY
This way you compare the datetime field with a constant (the expression
r
I'm using OpenBSD 3.6 (latest version) which comes with binary packages for
MySQL 4.0.20 - More recent binary packages are not yet available for this
platform and installation from source is not an option.
I have a table with datetime field and I would like to select all data
older than "X" wee
