No new stored procedure, or scalar/user defined functions are needed. There are a lot of answers here that are unnecessarily complex, or that don't account for daylight savings time. This query will work on any Azure SQL Server. SELECT CONVERT(DATETIME,GETDATE() AT TIME ZONE (SELECT CURRENT_TIMEZONE_ID()) AT TIME ZONE 'Eastern Standard Time')`
Adding this function into the ORIGINAL ANSWER below yields a single query will work globally on all Azure SQL Servers. SELECT CURRENT_TIMEZONE_ID() will return your server's timezone. DST is in effect between March and November and adds one hour time difference to UTC.The Azure SQL team has released a new function which makes this even easier. MDT is observed in almost all locations that observe Mountain Time, except the states of Arizona (US) and Sinaloa (Mexico). The largest city observing Mountain Daylight Time is Phoenix, followed by Denver and El Paso/Juarez. In Mexico, it is only the states in the north western corner of the country, including Baja California, Sinaloa and Chihuahua that observe MDT. The only province in Canada to be fully covered by MDT is Alberta whereas other provinces like British Columbia and Northwest Territories are split between MDT and PDT. MDT is observed in parts of Canada, the US and Mexico. In the US, Arizona, Colorado, Montana, Utah, New Mexico and Wyoming are all observing Mountain Daylight Time but there is also a bunch where part of the state observe MDT and part another time zone, like CDT or PDT. Countries observing Mountain Daylight Time: The name Mountain Daylight Time comes from it covering the Rocky Mountains in Western United States. In Mexico, this time zone is known as Zona Pacifico (Pacific Zone). It is 6 hours behind UTC and turns into MST in the summer. MDT is observed in the Western part of central US and Canada, as well as the North West corner of Mexico. As always, it is better to look up the actual location than the timezone itself. It is important to note that with the exception of Panama, Jamaica and a couple of locations in Canada and the US most in this time zone do observe DST and thus switch to EDT in the summer. Also some Caribbean locations such as Jamaica, Haiti and Panama are in this time zone. Locations such as New York, Washington, Quebec and Ontario are all on Eastern Standard Time. Most of the Eastern seaboard of the US observe EST, as well as most locations in Eastern Canada although there are a few exceptions. It is important to note that there is also Eastern Standard Time in Australia, but this is usually called AEST and thus not to be confused with EST. The origin of EST is the same as for most time zones – it was introduced when the railroad was built across the United States. It is in most places observed only in the winter months, from November to March. This is the standard time of the Eastern US, Canada and parts of the Caribbean.
0 kommentar(er)
