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

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/