use three parameters to create a date

Question

how can i pass 3 parameters to form a date in sql for example @year @month @day

Basically my program sends the parts of the date seperatly and i want them to be joined in the stored procedure.

score 1 · Answer 1 · answered Jan 07 '11 at 20:09

1

Good link on SQL Date functions:

answered Jan 07 '11 at 20:09

PMC

score 1 · Accepted Answer · edited May 23 '17 at 12:04

1

Here is SO answer to a similar question.

CAST(CAST(y AS varchar) + '-' + CAST(m AS varchar) + '-' + CAST(d AS varchar) AS DATETIME)

(I assume you know how to pass 3 parameters to stored procedure)

edited May 23 '17 at 12:04

Community

answered Jan 07 '11 at 20:10

Dani

hmmm it works but i cant get a dateadd to work in there is it possible to subtract the generated year by a parameter – MyHeadHurts Jan 07 '11 at 20:18

2 Answers2