-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Monday 07 June 2004 10:03 pm, starofframe wrote: > 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..
Here: http://dev.mysql.com/doc/mysql/de/Date_and_time_functions.html I gave you the function.. You can figure out how more to use it. - -- I don't have an attitude problem--it's supposed to be like this. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAxS8Mld4MRA3gEwYRAvWYAJ96EPnYuO79xu2BN1evRTD1KqLoJgCgkqJy J2jKgv4pvvc+7ImNlX7+qzc= =1DL5 -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]