On Tue, 19 Mar 2002, Horacio Lam wrote: > The folowing is a query I tried to do, to view reports that were > between two dates, the problem is that the reports that are made > on the second date, are not being display, if anyone can help me, please reply. > thanks > > > select ticket.t_id, t_summary, t_category, e_status, t_department, > e_assignedto, t_priority, t_timestamp_openend from ticket, events, tmpeid > where ticket.t_id = events.t_id and > events.e_id = tmpeid.e_id and t_timestamp_opened
> http://www.mysql.com/manual.php (the manual) Check the manual, but I think 'yyyy-mm-dd' means 'yyyy-mm-dd 00:00:00' change the final clause of the between to be 'yyyy-mm-dd 23:59:59'. hope this helps, Nigel --------------------------------------------------------------------- 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
