Help with UPDATE query
| From: | Shaun | Date: | Mon, 29 Sep 2003 22:00:27 +0000 |
| Subject: | Help with UPDATE query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30757@lists.php.net to get a copy of this message | ||
Hi,
I have two columns in my Bookings table of type DATETIME -
Booking_Start_Date and Boking_End_Date. How can i update every row so that
all of the times for Booking_Start_Date are 09.00 and all of the times for
Booking_End_Date are 17.30, without affecting any of the dates?
Thanks for your help