Re: Addtime is for 4.1, what can i use for 3.23? (pretty much 0T)

Hey, > Might be quicker for you to ask on a mysql mailing > list :) Yep, am waiting for the confirmation email... > I tried a couple of different things looking at the > mysql page > (http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html) > > but couldn't come up with a proper solution. Yep, then tried some weird stuff and it worked :-) INSERT INTO test2 VALUES (Curtime(), DATE_ADD(Now(), INTERVAL '5' minute)); Maybe this will help someone else out. Thanks for trying though. Cheers! Ryan ------ - The faulty interface lies between the chair and the keyboard. - Creativity is great, but plagiarism is faster! - Smile, everyone loves a moron. :-) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com