-
1. Re: How to define datepart Input variable in DATEADD (datepart , number , date ) method, so that it can be used as Source Supported Functions
shawkins Jun 28, 2016 6:48 PM (in response to ragava28)The major issue here is that datepart is expected to be a keyword - but the default rendering of the sql will produce a literal. This adds some difficultly in mapping to a user defined function.
SQLServer translator already maps the timestampadd system function to the SQLServer dateadd function and handles the source sql for you. Is there a reason you don't want to use the system timestampadd function?
-
2. Re: How to define datepart Input variable in DATEADD (datepart , number , date ) method, so that it can be used as Source Supported Functions
ragava28 Jun 28, 2016 9:16 PM (in response to shawkins)Steven ,
Thanks for response . You are right. Even I realized this after posting it in forum. Initially I tried executing timestampadd in SQL server directly, which was not working.so thought it is not supported by sql server. So ended up exploring other options which took me to DateAdd & pushing same to source.
Sorry for confusion.
Regards
Raghu