Question on inserting/updating into a Date field in SQL

[d2army]

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!

[Barand]

try

INSERT INTO TheTableWithOnlyDateField(TheDate) VALUES(ADDTIME (NOW(), "1:0:0") )

[fenway]

or NOW() + INTERVAL 1 HOUR