Hi Jeff,
you mean I can use sql like this
DELETE FROM table where date_sub(crea_dt, interval 1 day)
thanks a lot
Sukanto
----- Original Message -----
From: "Jeff Smelser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 08, 2004 8:55 AM
Subject: Re: delete record that passed > 1 day
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Monday 07 June 2004 08:36 pm, starofframe wrote:
> description like this : if now()-crea_dt > 0 then delete
select date_sub(crea_dt, interval 1 day)
- --
"If you're like me, and I know *I* am..." -- Joel Robinson
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAxRymld4MRA3gEwYRAubCAKCZQMtmxe04LtcOAND/u1I7GJOYtQCfdj1/
48Ab3kxyB3zrYmZsudqgXvQ=
=G+Ew
-----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]
