Hi
If you use from SQL 2008 you must use from bellow code:
DECLARE @Day As Int,
@Month As Int,
@Year As Int,
@Hour As Int,
@Minute As Int,
@Second As Int,
@Result As DateTime
Select @Day = Your Day,
@Month = Your Month,
@Year = Your Year,
@Hour = Your Hour,
@Minute = Your Minute,
@Second = Your Second,
Select @Result = DATEADD(SECOND, @Second , DATEADD(MINUTE, @Minute , DATEADD(HOUR, @Hour , DATEADD(MONTH, (@Year - 1900) * 12 + @Month - 1 , @Day - 1))))
On the other hand you must use:
DATEADD(SECOND, @Second , DATEADD(MINUTE, @Minute , DATEADD(HOUR, @Hour , DATEADD(MONTH, (@Year - 1900) * 12 + @Month - 1 , @Day - 1))))
Instead of:
DATETIMEFROMPARTS(Year(@StartDate), Month(@StartDate), Day(@StartDate), DATEPART(HOUR,@StartTimeTime), DATEPART(MINUTE,@StartTimeTime) , DATEPART(SECOND,@StartTimeTime) , 0)
I Hope it's helpful for you.
If you have question, Please tell me.