{"id":63513,"date":"2007-11-27T03:59:00","date_gmt":"2007-11-27T03:59:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2007\/11\/27\/hey-scripting-guy-how-can-i-retrieve-time-zone-information-for-a-computer\/"},"modified":"2007-11-27T03:59:00","modified_gmt":"2007-11-27T03:59:00","slug":"hey-scripting-guy-how-can-i-retrieve-time-zone-information-for-a-computer","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-how-can-i-retrieve-time-zone-information-for-a-computer\/","title":{"rendered":"Hey, Scripting Guy! How Can I Retrieve Time Zone Information for a Computer?"},"content":{"rendered":"

\"Hey, <\/H2>\n

Hey, Scripting Guy! How can I retrieve time zone information for a computer?

— AL<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, AL. You know, over the Thanksgiving Day weekend the Scripting Guy who writes this column took some time to think about his job, and to think of ways in which he could do that job even better. (Note to the Scripting Editor: Believe it or not, the Scripting Guy who writes this column isn\u2019t perfect. He does have some<\/I> room for improvement.) One of the conclusions the Scripting Guy who writes this column came to is this: a daily scripting column should be about scripting. A daily scripting column shouldn\u2019t be about a Scripting Guy riding an exercise bike<\/B><\/A> or ranting about people who abuse the express lane<\/B><\/A> at the grocery store. No, a daily scripting column should be about scripting, period. Therefore, no more personal anecdotes; from now on, we\u2019re all business all the time.<\/P>\n

You say you have a question first? You\u2019d like to know who won the 2007 Turducken Bowl<\/B><\/A>? Let\u2019s put it this way: it was the 2007 Turducken Bowl that caused the Scripting Guy who writes this column to swear off personal anecdotes forever.<\/P>\n\n<\/THEAD>\n\n\n
\n

Note<\/B>. Although we might point out that the Scripting Guy who writes this column did<\/I> score all seven of his team\u2019s touchdowns. That includes the touchdown he scored when he took the opening kickoff, faked a lateral to the Scripting Significant Other, and then ran right between the two flabbergasted defenders, giving his team an early 7-0 lead.<\/P>\n

And no, that\u2019s not a personal anecdote. That\u2019s just a statement of historical fact.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n

<\/DIV>\n

Besides, you know what they say: it\u2019s not whether you win or lose, it\u2019s how you play the game. And, unfortunately, the Scripting Guy who writes this column and his teammate didn\u2019t play the game very well this year.<\/P>\n

But that\u2019s OK; after all, this is a daily scripting column, it\u2019s not a column where we point out that the Scripting Guy who writes the column scored all seven<\/I> of his team\u2019s touchdowns. (Meaning that that his teammate must have scored \u2013 well, we\u2019ll let you do the math on that one.) Likewise, this isn\u2019t a column where we point out that the Scripting Son and Scripting Nephew were guilty of offensive pass interference on pretty much every single play; heaven forbid that we should even suggest<\/I> such a thing. Instead, this is a daily scripting column, a column where we show you how to do scripting type things. You know, things like retrieve time zone information for a computer:<\/P>

strComputer = “.”<\/p>\n
Set objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)\nSet colItems = objWMIService.ExecQuery(“Select * From Win32_TimeZone”)<\/p>\n
For Each objItem in colItems\n    Set colItems2 = objWMIService.ExecQuery(“Select * From Win32_ComputerSystem”)<\/p>\n
    For Each objItem2 in colItems2\n        blnDaylightInEffect = objItem2.DaylightInEffect\n    Next<\/p>\n
    If blnDaylightInEffect Then\n        Wscript.Echo objItem.DaylightName\n    Else\n        Wscript.Echo objItem.StandardName\n    End If\nNext\n<\/PRE>\n
As you can see, there really isn\u2019t much to this script. We start out by conencting to the WMI service on the local computer, then use the following line of code to return a collection of all the time zones that this computer belongs to:<\/P>
Set colItems = objWMIService.ExecQuery(“Select * From Win32_TimeZone”)\n<\/PRE>\n
And before you ask, the answer to both of your questions is this: yes. Yes, you can run this script against a remote computer; all you have to do is assign the name of that computer to the variable strComputer, like so:<\/P>
strComputer = “atl-fs-01”\n<\/PRE>\n
And yes, our collection will consist of just one item; that\u2019s because, barring any new discoveries in physics, a computer can only be in any one place \u2013 and any one time zone \u2013 at a time.<\/P>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. Wouldn\u2019t it have been nice if the Scripting Guy who writes this column could have been in more than one place at a time, enabling him to, say, both play quarterback and<\/I> wide receiver at the same time? Well, now that you mention it \u2026.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
Speaking of time zones, as you probably know, much of the world has a tendency to change times twice a year; in locations like that, part of the year takes place under Daylight Saving Time, and part of the year takes place under Standard Time. (Judging from the view outside the window right now, those of us in Redmond should have done a better job of actually saving<\/I> some daylight during Daylight Saving Time.) Maybe that doesn\u2019t matter to you; maybe all you care about is the name of the time zone itself. If that\u2019s the case, then the For Each loop we\u2019re about to set up (the one that loops through our collection of time zones) can be as simple as this:<\/P>
For Each objItem in colItems\n    Wscript.Echo objItem.Caption\nNext\n<\/PRE>\n
What does that give us? That gives us output that looks like this:<\/P>
(GMT-08:00) Pacific Time (US & Canada)\n<\/PRE>\n
That\u2019s good: it tells us the time zone (Pacific Time) that the computer is running under. What it doesn\u2019t<\/I> tell us, however, is whether the computer is currently running under Standard Time or Daylight Saving Time. So what the heck; let\u2019s see if we can figure that out as well.<\/P>\n
After all, that\u2019s the sort of thing you do in a daily scripting column, right?<\/P>\n
With that in mind, the first thing we do within the For Each loop is execute this line of code:<\/P>
Set colItems2 = objWMIService.ExecQuery(“Select * From Win32_ComputerSystem”)\n<\/PRE>\n
If you\u2019re looking at that and thinking, \u201cWow, that looks like we\u2019re running another WMI query,\u201d well, there\u2019s a good reason for that: we are<\/I> running another WMI query. Although the Win32_TimeZone<\/B> class tells us a considerable amount about a computer and its time zone (more on that in a minute) what it doesn\u2019t tell us is whether that computer is running under Daylight Saving Time or Standard Time. To get that<\/I> information we need to query the Win32_ComputerSystem<\/B> class. Which, needless to say, is exactly what we did.<\/P>\n
After executing our second query we next need to set up a second For Each loop, this one designed to loop through the collection of data returned by the Win32_ComputerSystem class. (Again, this will be a collection containing just one item.) Inside this second loop, we use the following line of code to assign the value of the DaylightInEffect<\/B> property to a variable named blnDaylightInEffect:<\/P>
blnDaylightInEffect = objItem2.DaylightInEffect\n<\/PRE>\n
What\u2019s the purpose of that? Well, DaylightInEffect is a Boolean value that tells us whether or not the computer is running under Daylight Saving Time. If DaylightInEffect is True that means that the computer is<\/I> running under Daylight Saving Time; if DaylightInEffect is False then that means the computer is running under Standard Time. That also means that all we have to do is examine the value of blnDaylightInEffect and echo back the appropriate message:<\/P>
If blnDaylightInEffect Then\n    Wscript.Echo objItem.DaylightName\nElse\n    Wscript.Echo objItem.StandardName\nEnd If\n<\/PRE>\n
As you probably figured out for yourself, DaylightName<\/B> not only gives us the name of the time zone but also tells us that the computer us running under Daylight Saving Time; StandardName<\/B> \u2013 well, you can definitely<\/I> figure out for yourself what StandardName does. When we ran this script in Remdond, WA on November 26, 2007 we got back the following:<\/P>
Pacific Standard Time\n<\/PRE>\n
Why? Because our computer is running under Pacific Standard Time, that\u2019s why. If we ran this script a month ago, back when Daylight Saving Time was still in effect, we would have gotten this message instead:<\/P>
Pacific Daylight Time\n<\/PRE>\n
Like we said, that information could be extremely useful, especially for enterprises who have computers in both Washington state (where we observe Daylight Saving Time) and in Arizona (where they don\u2019t<\/I> observe Daylight Saving Time.)<\/P>\n
But wait: we have a bonus script for you as well. (Yet another thing you\u2019d expect to find in a daily scripting column.) As we noted earlier, the Win32_TimeZone class gives you all sorts of information about a computer and its time zone. What kind<\/I> of information? Well, for one thing, Win32_TimeZone can tell you the exact date when you need to spring ahead (switch to Daylight Saving Time) or fall back (switch to Standard Time). In fact, here\u2019s a script that tells you that very thing:<\/P>
strComputer = “.”<\/p>\n
Set objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colItems = objWMIService.ExecQuery(“Select * From Win32_TimeZone”)<\/p>\n
For Each objItem in colItems\n    intMonth =  objItem.DaylightMonth\n    Select Case intMonth\n        Case 1 strMonth = “January”\n        Case 2 strMonth = “February”\n        Case 3 strMonth = “March”\n        Case 4 strMonth = “April”\n        Case 5 strMonth = “May”\n        Case 6 strMonth = “June”\n        Case 7 strMonth = “July”\n        Case 8 strMonth = “August”\n        Case 9 strMonth = “September”\n        Case 10 strMonth = “October”\n        Case 11 strMonth = “November”\n        Case 12 strMonth = “December”\n    End Select\n    intDayOfWeek = objItem.DayLightDayOfWeek\n    Select Case intDayOfWeek\n        Case 0 strDayOfWeek = “Sunday”\n        Case 1 strDayOfWeek = “Monday”\n        Case 2 strDayOfWeek = “Tuesday”\n        Case 3 strDayOfWeek = “Wednesday”\n        Case 4 strDayOfWeek = “Thursday”\n        Case 5 strDayOfWeek = “Friday”\n        Case 6 strDayOfWeek = “Saturday”\n    End Select\n    intDay = objItem.DaylightDay\n    Select Case intDay\n        Case 1 strDay = “first”\n        Case 2 strDay = “second”\n        Case 3 strDay = “third”\n        Case 4 strDay = “fourth”\n        Case 5 strDay = “last”\n    End Select        \n    Wscript.Echo “Daylight Saving Time begins on the ” & _\n        strDay & ” ” & strDayOfWeek & ” in ” & strMonth & “.”\n    intMonth =  objItem.StandardMonth\n    Select Case intMonth\n        Case 1 strMonth = “January”\n        Case 2 strMonth = “February”\n        Case 3 strMonth = “March”\n        Case 4 strMonth = “April”\n        Case 5 strMonth = “May”\n        Case 6 strMonth = “June”\n        Case 7 strMonth = “July”\n        Case 8 strMonth = “August”\n        Case 9 strMonth = “September”\n        Case 10 strMonth = “October”\n        Case 11 strMonth = “November”\n        Case 12 strMonth = “December”\n    End Select\n    intDayOfWeek = objItem.StandardDayOfWeek\n    Select Case intDayOfWeek\n        Case 0 strDayOfWeek = “Sunday”\n        Case 1 strDayOfWeek = “Monday”\n        Case 2 strDayOfWeek = “Tuesday”\n        Case 3 strDayOfWeek = “Wednesday”\n        Case 4 strDayOfWeek = “Thursday”\n        Case 5 strDayOfWeek = “Friday”\n        Case 6 strDayOfWeek = “Saturday”\n    End Select\n    intDay = objItem.StandardDay\n    Select Case intDay\n        Case 1 strDay = “first”\n        Case 2 strDay = “second”\n        Case 3 strDay = “third”\n        Case 4 strDay = “fourth”\n        Case 5 strDay = “last”\n    End Select        \n    Wscript.Echo “Standard Time begins on the ” & _\n        strDay & ” ” & strDayOfWeek & ” in ” & strMonth & “.”\nNext\n<\/PRE>\n
This is all a little complicated thanks to the way this information is stored. The DaylightMonth<\/B> property is an integer value representing the month (1 for January, 2 for February, etc.). The DaylightDayOfWeek<\/B> property is an integer value representing the day of the week when Daylight Saving Time begins (e.g., 0 equals Sunday, 1 equals Monday, and so on.) In other words, that property tells us that Daylight Saving Time begins on a Sunday. As to which<\/I> Sunday, well, that\u2019s the job of the DaylightDay<\/B> property. This is yet another integer value, with 1 representing the first (in our case) Sunday of the month, 2 representing the second Sunday of the month, etc.<\/P>\n
Like we said, it\u2019s a bit complicated, but the end result is simple enough:<\/P>
Daylight Saving Time begins on the second Sunday in March.\n<\/PRE>\n
And then we repeat this process with the corresponding Standard Time properties, resulting in output similar to this:<\/P>
Standard Time begins on the first Sunday in November.\n<\/PRE>\n
And the great circle of life goes on.<\/P>\n
That should do it, AL. And you know, after giving it a little more thought, we decided to go back to the good old days of Hey, Scripting Guy!<\/I>, the days when we did<\/I> talk about things other than system administration scripting. Let\u2019s see, what else went on this past weekend \u2026. What\u2019s that? The Apple Cup football game between the University of Washington Huskies and the Washington State Cougars? Right \u2026 Listen, have we mentioned lately that this is a daily scripting<\/I> column? The truth is, there are some things that should never be discussed in a daily scripting column.<\/P>\n
And there are also some things, like this year\u2019s Apple Cup, that should never be discussed at all. <\/P>\n
Ever.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I retrieve time zone information for a computer?— AL Hey, AL. You know, over the Thanksgiving Day weekend the Scripting Guy who writes this column took some time to think about his job, and to think of ways in which he could do that job even better. (Note to the […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[13,31,3,5],"class_list":["post-63513","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-dates-and-times","tag-operating-system","tag-scripting-guy","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I retrieve time zone information for a computer?— AL Hey, AL. You know, over the Thanksgiving Day weekend the Scripting Guy who writes this column took some time to think about his job, and to think of ways in which he could do that job even better. (Note to the […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/63513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=63513"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/63513\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=63513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=63513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=63513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}