how to set date parts in Date and Time Functions dynamicly
Posted on 2004-08-11
I have a Table with the following structure
datepart (varchar(4)) , timeIncrement (int)
I need to increment for each record, the current date based on the fields thah I have described above.
I had tryed this
select DATEADD(datepart , timeIncrement, GETDATE()) AS TheDateINeed
however, I recive this message
'datepart' is not a recognized dateadd option.