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?
What does
select curtime();
give you?
Make sure that's valid before trying to add to it..
Could also try:
select now() + interval 1 hour;
should come back the same (I think anyway).
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
