Hi Alec, Instead of adding 6 to current_time_stamp add 6000000. Hope the logic is clear.
Anvar. At 09:40 PM 26/11/2001 -0500, you wrote: >I've got a table containing dates as follows (number of rows edited for >length) > >mysql> select * from chat_schedule; >+-------------+----------+---------------------+ >| schedule_id | model_id | timeslot | >+-------------+----------+---------------------+ >| 1 | 2 | 2001-11-08 21:00:00 | >| 2 | 2 | 2001-11-08 22:00:00 | >| 3 | 5 | 2001-11-09 16:00:00 | >| 4 | 5 | 2001-11-09 17:00:00 | >| 5 | 3 | 2001-11-09 18:00:00 | >| 6 | 3 | 2001-11-09 19:00:00 | >| 7 | 2 | 2001-11-09 21:00:00 | >| 8 | 2 | 2001-11-09 22:00:00 | >| 9 | 5 | 2001-11-09 23:00:00 | >| 83 | 7 | 2001-11-26 18:00:00 | >| 85 | 7 | 2001-11-26 19:00:00 | >| 86 | 1 | 2001-11-26 20:00:00 | >| 87 | 2 | 2001-11-26 22:00:00 | >| 88 | 2 | 2001-11-26 23:00:00 | >| 89 | 8 | 2001-11-27 18:00:00 | >| 90 | 8 | 2001-11-27 19:00:00 | >| 91 | 1 | 2001-11-27 20:00:00 | >| 92 | 2 | 2001-11-27 22:00:00 | >| 93 | 2 | 2001-11-27 23:00:00 | >| 94 | 7 | 2001-11-28 18:00:00 | >| 95 | 7 | 2001-11-28 19:00:00 | >| 96 | 1 | 2001-11-28 20:00:00 | >| 97 | 2 | 2001-11-28 22:00:00 | >| 98 | 2 | 2001-11-28 23:00:00 | >| 99 | 7 | 2001-11-29 18:00:00 | >| 100 | 7 | 2001-11-29 19:00:00 | >| 101 | 1 | 2001-11-29 20:00:00 | >| 102 | 2 | 2001-11-29 22:00:00 | >| 103 | 2 | 2001-11-29 23:00:00 | >| 104 | 7 | 2001-11-30 18:00:00 | >| 107 | 2 | 2001-11-30 22:00:00 | >| 108 | 2 | 2001-11-30 23:00:00 | >| 109 | 7 | 2001-11-30 19:00:00 | >| 110 | 1 | 2001-11-30 20:00:00 | >| 111 | 7 | 2001-12-05 17:00:00 | >+-------------+----------+---------------------+ >104 rows in set (0.00 sec) > >When I run the query > >SELECT m.name,DATE_FORMAT(s.timeslot, '%W') as dayname, >DATE_FORMAT(s.timeslot, '%d') as date, DATE_FORMAT(s.timeslot, '%H') as >hour FROM models m, chat_schedule s WHERE m.model_id=s.model_id AND >s.timeslot >= CURRENT_TIMESTAMP() ORDER BY s.timeslot > >I get back the expected result -- all scheduled chats from today forward >for as many times are currently scheduled (23 rows returned). However if I run > >SELECT m.name,DATE_FORMAT(s.timeslot, '%W') as dayname, >DATE_FORMAT(s.timeslot, '%d') as date, DATE_FORMAT(s.timeslot, '%H') as >hour FROM models m, chat_schedule s WHERE m.model_id=s.model_id AND >s.timeslot >= CURRENT_TIMESTAMP() AND s.timeslot <= CURRENT_TIMESTAMP()+6 >ORDER BY s.timeslot > >zero rows are returned. How can I go about modifying query #1 so that only >chats scheduled for today and the next 6 days are returned (7 total days >worth)? I know my problem is calculating the dates for the second AND >clause, but I'm stumped as to where since the first portion works OK. > >Thanks in advance, >Alec > > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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
