[SOLVED] Mysql datetime

[freeloader]

Hi guys,

 

Just a quick question I couldn't find on google.

 

I have a datetime field storing a date and time like this: 2008-05-29 23:15:00. If I need to set the datetime 5 hrs further, is it possible to use the update function somehow? Like this:

 

UPDATE mytable SET datefield = 'NOW() + 5hrs'

 

Thanks in advance!

[DarkWater]

Look at the DATE_ADD or ADDDATE mysql functions.

[obsidian]

DarkWater has a good suggestion, but it turns out, you don't even have to incorporate those:

UPDATE mytable SET datefield = NOW() + INTERVAL 5 HOUR;

[freeloader]

Thanks

[freeloader]

Additional question: what if I want to add 5 hours and 1 minute? Or 1 day and 5 minutes?

[obsidian]

Additional question: what if I want to add 5 hours and 1 minute? Or 1 day and 5 minutes?

 

I believe you could just create an arithmetic operation:

UPDATE mytable SET datefield = (NOW() + INTERVAL 1 DAY + INTERVAL 5 MINUTE);

 

Try it out and see