Ok, This shouldn't be too hard but its still beating me...
The thing that's killing me here is that the time I'm trying to update is was, forwhatever reason, defined as varchar ('HH:MM:SS'). I need to add minutes to a stored time... Here's what I have...


Code:
UPDATE tasks SET 
alarm_time = DATE_ADD( 'alarm_time',  INTERVAL '00:05:00' HOUR_SECOND  )  WHERE task_id =729
The only thing this does is empty the field. What gives?

What am I doing wrong? Is there a better way?