http://dev.mysql.com/

On Tue, May 30, 2006 6:53 pm, 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?
>
> 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to