Jump to content

[SOLVED] Mysql datetime


freeloader

Recommended Posts

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!

Link to comment
https://forums.phpfreaks.com/topic/107874-solved-mysql-datetime/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.