Sql srver 2005 time conversion from american to indian time

Question

Can you tell me how to convert the american time to indian time. Just give me the function that converts the american time to Indian time. The time difference is 11.5 hours

Answer 1

Maybe there is more elegant solution, but as work around you can use T-SQL function DATEADD to add time difference between time zones