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

http://dev.mysql.com/ On Tue, May 30, 2006 6:53 pm, Ryan A wrote: > Hey, > To simplify this lets say my table looks like this: > > a time default NULL, > b time default NULL > > This is what i run: > INSERT INTO test2 VALUES (Curtime( ) , > ADDTIME(Curtime( ) , "00:01:00")) > > since the db is version 3.23 (I cant ask the client > to upgrade) instead of 4.1, the above SQL is not > possible and this: > > SELECT curtime( ) + INTERVAL 60 minute > > is giving me null, has anybody else faced this? if so > how did you solve this? > > I can of course run a query from my script to get the > curtime and then add minutes to it in my php script > and then insert it accordingly but it seems too much > of a PITA to do that... or I dont have a choice? > > Thanks! > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Like Music? http://l-i-e.com/artists.htm