On Thursday 21 March 2002 03:53, chris allen wrote:
> Hello,
>
>
> I am looking for a standard way to compare to dates. I have a date/time
> stored in a field in a mysql table as
> date_added TIMESTAMP(14). (IE mmddhhmmss).
>
> I want to delete all records in this table if date_added is ol
Hello,
I am looking for a standard way to compare to dates. I have a date/time
stored in a field in a mysql table as
date_added TIMESTAMP(14). (IE mmddhhmmss).
I want to delete all records in this table if date_added is older than 2
hours.
IE
if current_date > date_added +2 hours then
2 matches
Mail list logo