In message <[EMAIL PROTECTED]>, Ski Dawg <[EMAIL PROTECTED]> writes >I found the INTERVAL function in MySQL that would allow me to change the >time in a SELECT statement. That would allow me to do the following: > >SELECT submit_id, submit_time, (submit_time - INTERVAL 2 HOUR) as >new_submit_time FROM submits.
It's basically what was suggested in the previous reply. UPDATE submits SET submit_time = (submit_time-INTERVAL 2 HOUR) ... which *I* would test first... (:-> -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
