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

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(). 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