On Tue, 2005-10-04 at 08:31 +0200, Pete wrote: > 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... (:->
OK, thanks Pete and Jim for the information. I will give that a try later today. And yes, I will be testing it first. I have the database replicated to a testing server so that when I screw things up, I don't bring down the actual site ;-). -- Doug Registered Linux User #285548 (http://counter.li.org) ---------------------------------------- Random Thought: Cable. It's more wonderful than I dared hope. -- Homer Simpson Homer vs. Lisa and the 8th Commandment ------------------------ 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/
