sql server 2008 timeing related -


I have to find out what will be the time in India when the clock will be 1 AM at night in any other country. It will know that in any way, it helps me to know that it is to fire the birthright festivals at 1 p.m. of that birthplace ... then I have the following

  DECLARE @indianTime DATETIME - - = SYSDATETIMEOFFSET () DECLARE @timeZoneOffset NVARCHAR (6) = '+01: 00' SELECT SWITCHOFFSET (SYSDATETIMEOFFSET (), @timeZoneOffset)  

This gives me the current time of that country But I want that Watt will be the time when the country will have MDRA 1AM time ... using IAM SQL Server 2008

What your code does (at least, this is in my SQL 2008).

There is some way to trigger your query in real time (maybe some work is running per hour), or some helpful tables.

To add more details to your problem, other codes you already have, and so on, will help us assist you.


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -