mysql datetime for next week?

[craptakular]

How would you insert the datetime for next week at 15:00?

 

[Pho]

As in, you want the date of today + 1 week at 15:00?

 

[craptakular]

yes, thats right.

 

[Pho]

SELECT DATE_ADD(DATE(NOW() + INTERVAL 1 WEEK), INTERVAL 15 HOUR)

Possibly? Date(Now()) returns a date only (no time) so adding 15 hours to it brings it up to 15:00.

 

[craptakular]

can it not be used to update a row?

 

[Pho]

I can't see why not:

UPDATE X SET Y = DATE_ADD(DATE(NOW() + INTERVAL 1 WEEK), INTERVAL 15 HOUR)

 

[craptakular]

sorry for being thick... but how would you put that inside mysql_query?

 

[Pho]

Can you post what you have / what you're trying to do/update? Might be easier that way .

 

[craptakular]

Can I email you again like before?

 

[Pho]

Sure.

 

[craptakular]

mailed.