Yes, I did found out just now... but delete from table where date_sub(crea_dt, interval 1 day)<crea_dt should delete all data right??? All I want is compared to date_now.... eg : now is 2004-6-8 ....and all I want to delete is data that hav passed 1 or more days... such as L 2004-6-7,2004-6-6, etc..
so what's the suitable command then.. again thanks a lot Sukanto ----- Original Message ----- From: "Jeff Smelser" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 08, 2004 9:41 AM Subject: Re: delete record that passed > 1 day -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Monday 07 June 2004 09:22 pm, Jeff Smelser wrote: > On Monday 07 June 2004 09:25 pm, starofframe wrote: > > Hi Jeff, > > you mean I can use sql like this > > DELETE FROM table where date_sub(crea_dt, interval 1 day) > > Add: > crea_dt Could be <.. Damn, I always have to do a select first.. I get them backwards some times. - -- In nature, there are no rewards or punishments, only consequences. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAxSdFld4MRA3gEwYRAqvaAJ956TjRnblPfJLMWw3pUIiQV+ba4wCfbeVy o56hnpxuB5FnVqGmPMYhbC0= =um6f -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
