Re: select datetime older than X weeks

2005-01-07 Thread Jigal van Hemert
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 results

select datetime older than X weeks

2005-01-06 Thread Frank Bax
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