DATEADD Method

Question

Is it possible to use DATEADD() in insert command if not Please give me a method that can add specified number of years to current date to insert into table

Vulpes · Answer

When you say it's not working do you mean there's a syntax error or does nothing (or the wrong date) get inserted into the Date column?

Srikanth Suryadevara · Answer

insert into Fixd_Inv values(1234225102DATEADD(YYYY3'2013-04-10')) I wrote this but not working

Vulpes · Answer

AFAIK you can use expressions - not just simple values - in the VALUES(...) part of an INSERT command. So you should therefore be able to use the DATEADD() function.