hi people
this is the correct syntax:
delete from TABLE_NAME where DATE_ADD(TIMESTAMP_COLUMN, interval 3 day)
now()
the function to be used is outside the parenthesis, the column name inside;
this way mysql applies the function to the column (using the specified
parameters interval...
On 13-Aug-2001 hassan el forkani wrote:
hello;
can someone please help me with this query:
delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day)
now()
what i'm tryng to do is to delete all records that are 3 (or more) days old
i've looked around in the manual but
On Mon, 13 Aug 2001 02:47:32 +0200, hassan el forkani [EMAIL PROTECTED]
wrote:
hello;
can someone please help me with this query:
delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now()
what i'm tryng to do is to delete all records that are 3 (or more) days old
i've looked