Re: Problems with date arithmatic

2001-11-26 Thread Anvar Hussain K.M.
Hi Alec, Instead of adding 6 to current_time_stamp add 600. 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; >+-+--+-

Problems with date arithmatic

2001-11-26 Thread Alec Smith
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

Problems with date arithmatic

2001-11-26 Thread Alec Smith
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