Addtime is for 4.1, what can i use for 3.23? (pretty much 0T)
| From: | Ryan A | 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