Help With UPDATE Query in mySQL

Thread view:

Shaun - 03 Oct 2003 22:55 GMT

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

Reply to this Message

Frank Brouwer - 06 Oct 2003 14:52 GMT

Hi Shaun,

Try this:

update owner.table_name
set date_field_start = cast(convert(char, date_field_start, 12) + ' 09:00'
as datetime),
date_field_end = cast(convert(char, date_field_end, 12) + ' 17:30' as
datetime)

success,

Frank.

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks for your help

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...