Re: [PHP-DB] HELP With UPDATE Query in mySQL
and put it inside a transaction cos in case something goes wrong part of the way through pete Jeff Shapiro wrote: This should do it: UPDATE Bookings SET Booking_Start_Date = CONCAT(DATE_FORMAT(Booking_Start_Date, '%Y-%m-%d'), '09:00:00'), Booking_End_Date = CONCAT(DATE_FORMAT(Booking_End_Date, '%Y-%m-%d'), '17:30:00'); If you are using version 4.1.1 or newer the DATE_FORMAT function could be replaced by: DATE(Booking_Start_Date) On Fri, 3 Oct 2003 22:54:49 +0100, Shaun spoke thusly about [PHP-DB] HELP With UPDATE Query in mySQL: 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 --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] HELP With UPDATE Query in mySQL
This should do it: UPDATE Bookings SET Booking_Start_Date = CONCAT(DATE_FORMAT(Booking_Start_Date, '%Y-%m-%d'), '09:00:00'), Booking_End_Date = CONCAT(DATE_FORMAT(Booking_End_Date, '%Y-%m-%d'), '17:30:00'); If you are using version 4.1.1 or newer the DATE_FORMAT function could be replaced by: DATE(Booking_Start_Date) On Fri, 3 Oct 2003 22:54:49 +0100, Shaun spoke thusly about [PHP-DB] HELP With UPDATE Query in mySQL: > 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 --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] HELP With UPDATE Query in mySQL
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php