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

From: Date: Tue, 30 May 2006 23:53:43 +0000
Subject: Addtime is for 4.1, what can i use for 3.23? (pretty much 0T)
Groups: php.general 
Request: Send a blank email to php-general+get-237111@lists.php.net to get a copy of this message
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

« previous php.general (#237111) next »