Ryan A wrote:
Hey Chris,
...
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?
It gives me the correct time, eg:
03:23:01
Make sure that's valid before trying to add to it..
Yep, checked that, it is.
Could also try:
select now() + interval 1 hour;
should come back the same (I think anyway).
No, this works, its gives me back
2006-05-31 04:23:56
but I only need the time part not the date part thats
why i am using curtime().
Ah. Yes.
Might be quicker for you to ask on a mysql mailing list :)
I tried a couple of different things looking at the mysql page
(http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html)
but couldn't come up with a proper solution.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php