At 12:45 PM -0500 11/21/01, Auri Net SAC wrote: >Hi > >it is possible > >"select * from table where col1 <= now and col2>=now" > >where col1 and col2 are date type > >thnaks
Yes, except that it should be now() rather than now. --------------------------------------------------------------------- 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