Results 1 to 2 of 2
Thread: Update query
Feb 3, 2005, 17:46 #1
- Join Date
- Jan 2005
- 0 Post(s)
- 0 Thread(s)
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...
UPDATE tasks SET alarm_time = DATE_ADD( 'alarm_time', INTERVAL '00:05:00' HOUR_SECOND ) WHERE task_id =729
What am I doing wrong? Is there a better way?