d2army Posted January 12, 2007 Share Posted January 12, 2007 Hi there,I was hoping to consult with everyone on if it's possible to insert or update into a Date field in an SQL with this technique of using the now() function.The now() function returns the current date, but if I want to insert into the Date field a time that is exactly one hour from the current time(now() ), can I do something like :insert into TheTableWithOnlyDateField(TheDate) values("now()+1:00:00" ) I am not exactly how that now()+1:00:00 part should be phrased. Please help, thanks in advance! Link to comment https://forums.phpfreaks.com/topic/33866-question-on-insertingupdating-into-a-date-field-in-sql/ Share on other sites More sharing options...
Barand Posted January 12, 2007 Share Posted January 12, 2007 tryINSERT INTO TheTableWithOnlyDateField(TheDate) VALUES(ADDTIME (NOW(), "1:0:0") ) Link to comment https://forums.phpfreaks.com/topic/33866-question-on-insertingupdating-into-a-date-field-in-sql/#findComment-159462 Share on other sites More sharing options...
fenway Posted January 12, 2007 Share Posted January 12, 2007 or NOW() + INTERVAL 1 HOUR Link to comment https://forums.phpfreaks.com/topic/33866-question-on-insertingupdating-into-a-date-field-in-sql/#findComment-159557 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.