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

Reply via email to