= 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
TE_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. H
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
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