= 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
21 PM
Subject: [PHP-DB] Help with update...
> I'm working under the gun here, so please excuse me if this turns out to
be
> something really simple, but it's got me stumped... I'm trying to update
the
> "cover" field in a table by using the album_id field in
I'm working under the gun here, so please excuse me if this turns out to be
something really simple, but it's got me stumped... I'm trying to update the
"cover" field in a table by using the album_id field in the table and adding
a ".jpg" extention to it...
For example:
"Update albums set cover =
