Re: Help with an UPDATE query please

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Presuming you have the date in your PHP code you could simply add 172800 (seconds in 2 days) to the current value and insert it in the same way as you are doing with your current dates.

If you post how you're inserting your dates, what format you're using and stuff like that then you'll probably get more concise help.

Shaun wrote:
Hi,

I have (among others) two DATE columns in a table; Booking_Date and
Booking_Completion_Date. How can I run a query that updates
Booking_Completion_Date to be 2 days after Booking_Date where
Booking_Completion_Date is NULL?

Many thanks


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux