Sql Server 2005 time conversion from american to indian time

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开发者_JAVA百科

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