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! Quote Link to comment 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") ) Quote Link to comment Share on other sites More sharing options...
fenway Posted January 12, 2007 Share Posted January 12, 2007 or NOW() + INTERVAL 1 HOUR Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.