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 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 o
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 b
