inserting current date values into columns

Question

Can you insert current date via a function with an insert statement?

Should look something like this:

insert into table name 
values
(getdate(), getdate()-1)
,(getdate(), getdate()-1)

The above example may be vague but can this concept be done?

@Giorgi Nakeuri ..u dont know the situation some would have been still studying and have no access immediately to a system and thinking it theoretically — AK SQL, Apr 22 '16 at 14:42

score 1 · Answer 1 · answered Apr 22 '16 at 14:42

1

In a word - yes. You can use the results of function calls or calculations as arguments to a values clause of an insert statement.

answered Apr 22 '16 at 14:42

Mureinik

thank you so it will be like ((select getdate()), (select getdate()-1)) – AK SQL Apr 22 '16 at 14:45

score 1 · Accepted Answer · answered Apr 22 '16 at 14:46

1

Yes you can manipulate function directly

SELECT GETDATE()-1

But I will Suggets use DATEADD function

SELECT DATEADD(D,-1,GETDATE())

answered Apr 22 '16 at 14:46

Jaydip Jadhav

ty.. theoretically what difference it will give using date add instead of direct function manipulation – AK SQL Apr 22 '16 at 14:49
1

`DATEADD` function internally manages what needs to add whether it is `DAY -->D`,`YEAR-->Y` or etc – Jaydip Jadhav Apr 22 '16 at 14:55
1

one interesting thing that if you try `SELECT sysdatetime() - 1` this will give error – Jaydip Jadhav Apr 22 '16 at 14:56

2 Answers2