Re: how do I purge data from a database table

On 12 Apr 2002 03:15:01 -0700, ekearney_at_ddsi.ie (Edel) wrote:

Describe you table and see if you have a column with date format.

Then

Delete from table where datecol < sysdate-180;

If not you will need to find a way to identify where criteria.

>I need to purge data from a database table where the entries in the
>table are more than 6 months old. I have no idea how to do
>this...anybody know how this can be done?????
Received on Fri Apr 12 2002 - 05:48:37 CDT