Dear my friend, I am using MySQL as database server. I still have problem now to select appointment time whose 3 minute difference (later) than now().
I can not use "timestampdiff". Is there "TimeStampDiff " command in MySQL ? I tried this command but it didn't work : " select * from appointment where date=curdate() and timestampdiff(2, time, concat(hour(now()),':',minute(now()) ); " Thank you very much in advance. __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php