Dealing with dates, times and durations

this article requires javascript knowledge dates and times servicely comes with an object called datetime there is one static instance of this object that can be used to access contants (see below) a new datetime object can be created by using this construct var d = datetime(); datetime comes with many modifiers that can be chained because they all return the same datetime object this makes the initialisation of a new object quite easy because we can put that kind of constructs together var d = datetime() withdate(1997, 7, 26) withtimeatstartofday() withlang('fr') withzone('europe/brussels'); datetime also comes with many very useful functions to manipulate and display dates and times they are all explained in the following chapters note in all the examples of this section we will use this date and time as an example april 6th, 1968 at 18 25 32 (or 6 25 32 pm) and 678 milliseconds the iso 8601 string representation of this date/time is 1968 04 06t18 25 32 678 static constants servicely comes with a static global datetime object and a set of constants that can be used to make the source code more readable constant value represents datetime january 1 the month of january datetime february 2 the month of february datetime march 3 the month of march datetime april 4 the month of april datetime may 5 the month of may datetime june 6 the month of june datetime july 7 the month of july datetime august 8 the month of august datetime september 9 the month of september datetime october 10 the month of october datetime november 11 the month of november datetime december 12 the month of december datetime monday 1 the day of the week monday datetime tuesday 2 the day of the week tuesday datetime wednesday 3 the day of the week wednesday datetime thursday 4 the day of the week thursday datetime friday 5 the day of the week friday datetime saturday 6 the day of the week saturday datetime sunday 7 the day of the week sunday http //datetime am 0 the morning http //datetime pm 1 the afternoon datetime bc datetime bce 0 before christ before common era http //datetime ad datetime ce 1 anno domini common era datetime millis per second 1,000 number of milliseconds per second datetime millis per minute 60,000 number of milliseconds per hour datetime millis per hour 3,600,000 number of milliseconds per hour datetime millis per day 86,400,000 number of milliseconds per day datetime millis per week 604,800,000 number of milliseconds per week datetime seconds per minute 60 number of seconds per minute datetime seconds per hour 3,600 number of seconds per hour datetime seconds per day 86,400 number of seconds per day datetime seconds per week 604,800 number of seconds per week datetime minutes per hour 60 number of minutes per hour datetime minutes per day 1,440 number of minutes per day datetime minutes per week 10,080 number of minutes per week datetime hours per day 24 number of hours per day datetime hours per week 168 number of hours per week datetime days per week 7 number of days per week available functions function returns description getters getyear() integer returns the year of the given datetime object getmonthofyear() integer returns the month of the given datetime object note that january has the value of 1 getdayofmonth() integer returns the day of the month of the given datetime object gethourofday() integer returns the hour of the given datetime object getminuteofhour() integer returns the minute number of the given datetime object getsecondofminute() integer returns the second number of the given datetime object getmillisofsecond() integer returns the millisecond number of the given datetime object getzone() string returns the current time zone of the given datetime object returns an empty string if no specific time zone has been set for this object see function withxxx() modifiers withdate( year, month, day) datetime sets the date to the one corresponding year , month and day and returns the modified object calling withdate() with no parameters defaults the date to 31 december 1900 note that it leaves the time untouched withtime( hour, minute, second, millisecond datetime sets the time to the one corresponding to hour , minutes , second, millisecond any ommited parameter will be defaulted to 0 calling withtime() with no parameters at all will default the time to 00 00 00 000 note that it leaves the date untouched withyear( year) datetime sets the year to year and returns the modified object withmonthofyear( month) datetime sets the month to month and returns the modified object withdayofmonth( day) datetime sets the day to day and returns the modified object withhourofday( hour) datetime sets the hour to hour and returns the modified object withminuteofhour( minute) datetime sets the day to minute and returns the modified object withsecondsofminute( seconds) datetime sets the minute to seconds and returns the modified object withmillisofsecond( milliseconds) datetime sets the millisecond to milliseconds and returns the modified object withtimeatstartofday() datetime sets the time of the datetime object to the start of the day, that is 00 00 00 000 in the object current time zone withlang( language) datetime sets the language of the datetime to language we use the iso 639 1 two letter codes for representing the language; the list can be found http //en wikipedia org/wiki/list of iso 639 1 codes withzone( timezone) datetime sets the time zone of the datetime see section for more information about the time zone and the datetime object date and time comparisons isequal( datetime) boolean returns true if datetime has exactly the same date and time of the object, false otherwise isafter( datetime) boolean returns true if datetime if strictly after the date and time of the object, false otherwise isbefore( datetime) boolean returns true if datetime if strictly before the date and time of the object, false otherwise isafterorequalto( datetime) boolean returns true if datetime if after or equal the date and time of the object, false otherwise isbeforeorequalto( datetime) boolean returns true if datetime if before or equal the date and time of the object, false otherwise issameday( datetime) boolean returns true if datetime has the same date of the object, regardless of the time return false otherwise isleapyear() boolean returns true if datetime is in a leap year isdaylightsavings() boolean returns true if datetime is in daylight savings time doing your math! plusyears( years) minusyears( years) datetime adds or substracts the number of years to the datetime object and returns it plusmonths( months) minusmonths( months) datetime adds or substracts the number of months to the datetime object and returns it plusweeks( weeks) minusweeks( weeks) datetime adds or substracts the number of weeks to the datetime object and returns it plusdays( days) minusdays( days) datetime adds or substracts the number of days to the datetime object and returns it plushours( hours) minushours( hours) datetime adds or substracts the number of hours to the datetime object and returns it plusminutes( minutes) minusminutes( minutes) datetime adds or substracts the number of minutes to the datetime object and returns it plusseconds( seconds) minusseconds( seconds) datetime adds or substracts the number of seconds to the datetime object and returns it plusmillis( milliseconds) minusmillis( milliseconds) datetime adds or substracts the number of milliseconds to the datetime object and returns it plusduration(duration)minusduration(duration) duration adds or subtracts the duration from the datetime object and returns it formatting format( formatter) string format and returns the date/time using the pattern specified by the formatter see section https //docs servicely atlassian net/wiki/spaces/sd/pages/2140209155/dealing+with+dates+times+and+durations#%5binlineextension%5dformatting the date and time output for more information this subject toisoformat() string returns the iso 8601 format of the date and time more information about this format can be found http //en wikipedia org/wiki/iso 8601 tostring() string returns an iso 8601 formatted string of the date/time tostring() is similar to toisoformat() with the exception of the time offset representation if there is none the letter "z" will be displayed instead of +00 00 ``` datetime() withzone('gmt') tostring(); ```> `2013 11 20t10 08 14 363z```` datetime() withzone('gmt') toisoformat(); ```> 2013 11 20t10 08 14 363+00 00 fromnow() string returns a string indicating the elapsed time between now and the datetime object the string can be one of those patterns in \<litteral number> year(s) | month(s) | day(s) | hour(s) | minute(s) | second(s) \<litteral number> year(s) | month(s) | day(s) | hour(s) | minute(s) | second(s) ago in a few seconds a few seconds ago depending on whether the current time is before or after the datetime object the string patterns above are in english but note that they are localised; therefore you will obtain a different string if you have changed the language with | \| truncating times | | | \| truncatehours() | datetime | returns a datetime with the hours, minutes, seconds, and milliseconds components zeroed out | \| truncateminutes() | datetime | returns a datetime with the minutes, seconds, and milliseconds components zeroed out | \| truncateseconds() | datetime | returns a datetime with the seconds and milliseconds components zeroed out | \| truncatemillis() | datetime | returns a datetime with the milliseconds component zeroed out | \| tostartofday() | datetime | returns a datetime with the time component set to 00 00 00 0 | \| toendofday() | datetime | returns a datetime with the time component set to 23 59 59 999 | if you don’t see the datetime you need, we have other less used api options found docid\ vdcgsj1tcie1hzhxvrh4b about the time zone when dealing with dates and times, it is very important to always consider what time zone we work in by default, datetime parses and displays in local time, that is the time of the system servicely runs on we can use function to change the time zone we work against datetime() withzone('europe/paris'); we use the http //en wikipedia org/wiki/tz database naming convention which is in the form of "area/location", e g "america/new york" punctuation is omitted and the underscore character is used in place of spaces hyphens are used where they appear in the name of a location the list of the currently supported time zones can be found it is vital for the datetime object to always work with the proper time zone besides indicating the time difference, the time zone also has important properties like daylight savings not setting the correct time zone may result in improper date conversions and calculations getting current date and time to get the current date and time, just create a new datetime() with no parameters var now = datetime(); getting a specific date and time to obtain a datetime object set with a date time of your choice, pass an array of the date/time elements to the constructor var d = datetime( \[ 1968, datetime april, 6, 18, 25, 32, 678 ] ); the above returns a datetime object set to november 27th, 1968 with time 18 25 32 and 678 milliseconds the structure of the array is \[ year, month, day, hour, minute, second, millisecond ] where year and month are mandatory any other elements will be defaulted by the constructor should they be missing the day will be defaulted to 1 and all the time elements will be defaulted to 0 another way of initializing a date/time object is to use a combination of withdate() and withtime() functions setting the a datetime object to the same value than above would be achieved by this construct var d = datetime() withdate(1968, datetime april, 6) withtime(18, 25, 32, 678); finally, we can go one level down and call each specific modifier function for each element of the date/time this (very unlikely) construct would be like this var d = datetime() withyear(1968) withmonthofyear(datetime april) withdayofmonth(6) withhourofday(18) withminuteofhour(25) withsecondsofminute(32) withmillisofsecond(678); formatting the date and time output a datetime object can be printed in any desired format by using the format() function it takes a formatter string made of tokens and replaces them with their corresponding values the table below lists the available tokens date/time element token output month m 1 2 11 12 mo 1st 2nd 11th 12th mm 01 02 11 12 mmm jan feb nov dec mmmm january february november december day of month d 1 2 30 31 do 1st 2nd 30th 31st dd 01 02 30 31 day of year ddd 1 2 364 365 dddo 1st 2nd 364th 365th dddd 001 002 364 365 day of week d 0 1 5 6 do 0th 1st 5th 6th dd su mo fr sa ddd sun mon fri sat dddd sunday monday friday saturday week of year w 1 2 52 53 wo 1st 2nd 52nd 53rd ww 01 02 52 53 year yy 70 71 29 30 yyyy 1970 1971 2029 2030 am/pm a am pm a am pm hour h 0 1 22 23 hh 00 01 22 23 h 1 2 11 12 hh 01 02 11 12 minute m 0 1 58 59 mm 00 01 58 59 second s 0 1 58 59 ss 00 01 58 59 fractional second s 0 1 8 9 ss 0 1 98 99 sss 0 1 998 999 time zone z 07 00 06 00 +06 00 +07 00 zz 0700 0600 +0600 +0700 unix timestamp x 1360013296 note that using format() with no formatter will return the iso format string, without the milliseconds datetime() format(); 2013 11 20t10 14 46+10 00 pre built formatters datetime comes with prebuilt formatters, summarised in the table below date/time element formatter example output time lt 6 25 pm month numeral, day of month, year l 04/06/1968 l 4/6/1968 month name, day of month, year ll april 6 1968 ll apr 6 1968 month name, day of month, year, time lll april 6 1968 6 25 pm lll apr 6 1968 6 25 pm month name, day of month, day of week, year, time llll saturday, april 6 1968 6 25 pm llll sat, apr 6 1968 6 25 pm localising datetime output any output will be localised, assuming the proper language has been set by using the function for example datetime( \[ 1968, datetime april, 6, 18, 25, 32, 678 ] ) format('llll'); sat, apr 6 1968 6 25 pm whereas datetime( \[ 1968, datetime april, 6, 18, 25, 32, 678 ] ) withlang('fr') format('llll'); sam 6 avr 1968 18 25 the following tokens and formatters are impacted by the localisation all prebuilt formatters mo, mmm, mmmm do, dddo do, ddd, dddd wo escaping substrings any substrings in the formatter can be escaped by using square brackets, for example datetime( \[ 1968, datetime april, 6, 18, 25, 32, 678 ] ) format('lll\[ was a ]dddd\[ and was the ]dddo\[day of the year ]'); april 6 1968 6 25 pm was a saturday and was the 97th day of the year durations servicely uses iso 8601 format for representing durations it is a string made of a series of value/capital letter pairs the capital letter designates the date and time element, using this convention p\[n]y\[n]m\[n]dt\[n]h\[n]m\[n]s where n represents the value for each of the date and time elements p is the duration designator always placed at the start of the string, even there are no date elements in the duration; y represents the years; m represents the months; w represents the weeks; d represents the days; t represents the time designator that precedes the time components of the representation the time designator is present only if the duration has time elements in it; h represents the hours; m represents the minutes; s represents the seconds milliseconds are also represented using the "s" letter but with a decimal value for example 400 milliseconds will be displayed using this notation pt0 400s examples "p3y6m4dt12h30m5s" represents three years, six months, four days, twelve hours, thirty minutes, and five seconds "p6dt40s" represents six days and 40 seconds "p1m" represents one month "pt1m" represents one minute getting a brand new duration a new duration can easily be created by instantiating a new period object and using one of the withxxx() methods note that those function can be chained to build the exact wanted duration var p = period() withdays(5) withhours(10) withminutes(25) withseconds(40) withmillis(350); log info(p tostring()); this will display p5dt10h25m40 350s getting a duration from two date time's an easy way of initializing a new duration is to take dates (possibly with time) and get the difference in a period format var now = datetime(); var earlier = datetime() withdate(2020, 1, 1) withtime(15,30,0); var duration = duration(earlier, now); var period = period(duration); period; would return something like that (depending on which day is today) p6y1m1w6dt13h59m26 849s available functions function returns description getters getstandarddays() integer returns number of standardized days represented by the duration getstandardhours() integer returns number of standardized hours represented by the duration getstandardminutes() integer returns number of standardized minutes represented by the duration getstandardseconds() integer returns number of standardized seconds represented by the duration getmillis() integer returns number of milliseconds represented by the duration methods plus(duration | period | number) duration adds the supplied duration, period, or number (milliseconds) to the duration and returns it (original is immutable) minus(duration | period | number) duration subtracts the supplied duration, period, or number (milliseconds) to the duration and returns it (original is immutable) plusdays(number) duration adds the number of days to the duration (negative to subtract) plushours(number) duration adds the number of hours to the duration (negative to subtract) plusminutes(number) duration adds the number of minutes to the duration (negative to subtract) plusseconds(number) duration adds the number of hours to the duration (negative to subtract) plusmillis(number) duration adds the number of milliseconds to the duration (negative to subtract) minusdays(number) duration subtracts the number of days to the duration (requires release 1 5) minushours(number) duration subtracts the number of hours to the duration (requires release 1 5) minusminutes(number) duration subtracts the number of minutes to the duration (requires release 1 5) minusseconds(number) duration subtracts the number of hours to the duration (requires release 1 5) minusmillis(number) duration subtracts the number of milliseconds to the duration (requires release 1 5) the periodcalculator object the leavecalculator object addendum list of supported languages language code language ar arabic ar ma moroccan arabic bg bulgarian ca catalan cz czech cv chuvash da danish de german el modern greek en ca canadian english en gb great britain english eo esperanto es spanish et estonian eu euskara fi finnish fr french fr ca canadian french gl galician he hebrew hi hindi hu hungarian id bahasa indonesia is icelandic it italian ja japanese ko korean la latvian ms my bahasa malaysia nb norwegian bokmål ne nepali/nepalese nl dutch pl polish pt portuguese pt br brazilian portuguese ro romanian ru russian sl slovenian sv swedish th thai tr turkish tzm morocco central atlas tamaziɣt tzm la morocco central atlas tamaziɣt in latin uk ukrainian zh cn chinese zh tw traditional chinese list of time zones africa/abidjan greenwich mean time africa/accra ghana mean time africa/addis ababa eastern african time africa/algiers central european time africa/asmara eastern african time africa/asmera eastern african time africa/bamako greenwich mean time africa/bangui western african time africa/banjul greenwich mean time africa/bissau greenwich mean time africa/blantyre central african time africa/brazzaville western african time africa/bujumbura central african time africa/cairo eastern european time africa/casablanca western european time africa/ceuta central european time africa/conakry greenwich mean time africa/dakar greenwich mean time africa/dar es salaam eastern african time africa/djibouti eastern african time africa/douala western african time africa/el aaiun western european time africa/freetown greenwich mean time africa/gaborone central african time africa/harare central african time africa/johannesburg south africa standard time africa/kampala eastern african time africa/khartoum eastern african time africa/kigali central african time africa/kinshasa western african time africa/lagos western african time africa/libreville western african time africa/lome greenwich mean time africa/luanda western african time africa/lubumbashi central african time africa/lusaka central african time africa/malabo western african time africa/maputo central african time africa/maseru south africa standard time africa/mbabane south africa standard time africa/mogadishu eastern african time africa/monrovia greenwich mean time africa/nairobi eastern african time africa/ndjamena western african time africa/niamey western african time africa/nouakchott greenwich mean time africa/ouagadougou greenwich mean time africa/porto novo western african time africa/sao tome greenwich mean time africa/timbuktu greenwich mean time africa/tripoli eastern european time africa/tunis central european time africa/windhoek western african time america/adak hawaii aleutian standard time america/anchorage alaska standard time america/anguilla atlantic standard time america/antigua atlantic standard time america/araguaina brasilia time america/argentina/buenos aires argentine time america/argentina/catamarca argentine time america/argentina/comodrivadavia argentine time america/argentina/cordoba argentine time america/argentina/jujuy argentine time america/argentina/la rioja argentine time america/argentina/mendoza argentine time america/argentina/rio gallegos argentine time america/argentina/salta argentine time america/argentina/san juan argentine time america/argentina/san luis argentine time america/argentina/tucuman argentine time america/argentina/ushuaia argentine time america/aruba atlantic standard time america/asuncion paraguay time america/atikokan eastern standard time america/atka hawaii aleutian standard time america/bahia brasilia time america/barbados atlantic standard time america/belem brasilia time america/belize central standard time america/blanc sablon atlantic standard time america/boa vista amazon time america/bogota colombia time america/boise mountain standard time america/buenos aires argentine time america/cambridge bay mountain standard time america/campo grande amazon time america/cancun central standard time america/caracas venezuela time america/catamarca argentine time america/cayenne french guiana time america/cayman eastern standard time america/chicago central standard time america/chihuahua mountain standard time america/coral harbour eastern standard time america/cordoba argentine time america/costa rica central standard time america/cuiaba amazon time america/curacao atlantic standard time america/danmarkshavn greenwich mean time america/dawson pacific standard time america/dawson creek mountain standard time america/denver mountain standard time america/detroit eastern standard time america/dominica atlantic standard time america/edmonton mountain standard time america/eirunepe amazon time america/el salvador central standard time america/ensenada pacific standard time america/fort wayne eastern standard time america/fortaleza brasilia time america/glace bay atlantic standard time america/godthab western greenland time america/goose bay atlantic standard time america/grand turk eastern standard time america/grenada atlantic standard time america/guadeloupe atlantic standard time america/guatemala central standard time america/guayaquil ecuador time america/guyana guyana time america/halifax atlantic standard time america/havana cuba standard time america/hermosillo mountain standard time america/indiana/indianapolis eastern standard time america/indiana/knox central standard time america/indiana/marengo eastern standard time america/indiana/petersburg eastern standard time america/indiana/tell city central standard time america/indiana/vevay eastern standard time america/indiana/vincennes eastern standard time america/indiana/winamac eastern standard time america/indianapolis eastern standard time america/inuvik mountain standard time america/iqaluit eastern standard time america/jamaica eastern standard time america/jujuy argentine time america/juneau alaska standard time america/kentucky/louisville eastern standard time america/kentucky/monticello eastern standard time america/knox in central standard time america/la paz bolivia time america/lima peru time america/los angeles pacific standard time america/louisville eastern standard time america/maceio brasilia time america/managua central standard time america/manaus amazon time america/marigot atlantic standard time america/martinique atlantic standard time america/mazatlan mountain standard time america/mendoza argentine time america/menominee central standard time america/merida central standard time america/mexico city central standard time america/miquelon pierre & miquelon standard time america/moncton atlantic standard time america/monterrey central standard time america/montevideo uruguay time america/montreal eastern standard time america/montserrat atlantic standard time america/nassau eastern standard time america/new york eastern standard time america/nipigon eastern standard time america/nome alaska standard time america/noronha fernando de noronha time america/north dakota/center central standard time america/north dakota/new salem central standard time america/panama eastern standard time america/pangnirtung eastern standard time america/paramaribo suriname time america/phoenix mountain standard time america/port au prince eastern standard time america/port of spain atlantic standard time america/porto acre amazon time america/porto velho amazon time america/puerto rico atlantic standard time america/rainy river central standard time america/rankin inlet central standard time america/recife brasilia time america/regina central standard time america/resolute eastern standard time america/rio branco amazon time america/rosario argentine time america/santarem brasilia time america/santiago chile time america/santo domingo atlantic standard time america/sao paulo brasilia time america/scoresbysund eastern greenland time america/shiprock mountain standard time america/st barthelemy atlantic standard time america/st johns newfoundland standard time america/st kitts atlantic standard time america/st lucia atlantic standard time america/st thomas atlantic standard time america/st vincent atlantic standard time america/swift current central standard time america/tegucigalpa central standard time america/thule atlantic standard time america/thunder bay eastern standard time america/tijuana pacific standard time america/toronto eastern standard time america/tortola atlantic standard time america/vancouver pacific standard time america/virgin atlantic standard time america/whitehorse pacific standard time america/winnipeg central standard time america/yakutat alaska standard time america/yellowknife mountain standard time asia/aden arabia standard time asia/almaty alma ata time asia/amman eastern european time asia/anadyr anadyr time asia/aqtau aqtau time asia/aqtobe aqtobe time asia/ashgabat turkmenistan time asia/ashkhabad turkmenistan time asia/baghdad arabia standard time asia/bahrain arabia standard time asia/baku azerbaijan time asia/bangkok indochina time asia/beirut eastern european time asia/bishkek kirgizstan time asia/brunei brunei time asia/calcutta india standard time asia/choibalsan choibalsan time asia/chongqing china standard time asia/chungking china standard time asia/colombo india standard time asia/dacca bangladesh time asia/damascus eastern european time asia/dhaka bangladesh time asia/dili timor leste time asia/dubai gulf standard time asia/dushanbe tajikistan time asia/gaza eastern european time asia/harbin china standard time asia/ho chi minh indochina time asia/hong kong hong kong time asia/hovd hovd time asia/irkutsk irkutsk time asia/istanbul eastern european time asia/jakarta west indonesia time asia/jayapura east indonesia time asia/jerusalem israel standard time asia/kabul afghanistan time asia/kamchatka petropavlovsk kamchatski time asia/karachi pakistan time asia/kashgar china standard time asia/katmandu nepal time asia/kolkata india standard time asia/krasnoyarsk krasnoyarsk time asia/kuala lumpur malaysia time asia/kuching malaysia time asia/kuwait arabia standard time asia/macao china standard time asia/macau china standard time asia/magadan magadan time asia/makassar central indonesia time asia/manila philippines time asia/muscat gulf standard time asia/nicosia eastern european time asia/novosibirsk novosibirsk time asia/omsk omsk time asia/oral oral time asia/phnom penh indochina time asia/pontianak west indonesia time asia/pyongyang korea standard time asia/qatar arabia standard time asia/qyzylorda qyzylorda time asia/rangoon myanmar time asia/riyadh arabia standard time asia/riyadh87 gmt+03 07 asia/riyadh88 gmt+03 07 asia/riyadh89 gmt+03 07 asia/saigon indochina time asia/sakhalin sakhalin time asia/samarkand uzbekistan time asia/seoul korea standard time asia/shanghai china standard time asia/singapore singapore time asia/taipei china standard time asia/tashkent uzbekistan time asia/tbilisi georgia time asia/tehran iran standard time asia/tel aviv israel standard time asia/thimbu bhutan time asia/thimphu bhutan time asia/tokyo japan standard time asia/ujung pandang central indonesia time asia/ulaanbaatar ulaanbaatar time asia/ulan bator ulaanbaatar time asia/urumqi china standard time asia/vientiane indochina time asia/vladivostok vladivostok time asia/yakutsk yakutsk time asia/yekaterinburg yekaterinburg time asia/yerevan armenia time atlantic/azores azores time atlantic/bermuda atlantic standard time atlantic/canary western european time atlantic/cape verde cape verde time atlantic/faeroe western european time atlantic/faroe western european time atlantic/jan mayen central european time atlantic/madeira western european time atlantic/reykjavik greenwich mean time atlantic/south georgia south georgia standard time atlantic/st helena greenwich mean time atlantic/stanley falkland is time australia/act eastern standard time (new south wales) australia/adelaide central standard time (south australia) australia/brisbane eastern standard time (queensland) australia/broken hill central standard time (south australia/new south wales) australia/canberra eastern standard time (new south wales) australia/currie eastern standard time (new south wales) australia/darwin central standard time (northern territory) australia/eucla central western standard time (australia) australia/hobart eastern standard time (tasmania) australia/lhi lord howe standard time australia/lindeman eastern standard time (queensland) australia/lord howe lord howe standard time australia/melbourne eastern standard time (victoria) australia/nsw eastern standard time (new south wales) australia/north central standard time (northern territory) australia/perth western standard time (australia) australia/queensland eastern standard time (queensland) australia/south central standard time (south australia) australia/sydney eastern standard time (new south wales) australia/tasmania eastern standard time (tasmania) australia/victoria eastern standard time (victoria) australia/west western standard time (australia) australia/yancowinna central standard time (south australia/new south wales) europe/amsterdam central european time europe/andorra central european time europe/athens eastern european time europe/belfast greenwich mean time europe/belgrade central european time europe/berlin central european time europe/bratislava central european time europe/brussels central european time europe/bucharest eastern european time europe/budapest central european time europe/chisinau eastern european time europe/copenhagen central european time europe/dublin greenwich mean time europe/gibraltar central european time europe/guernsey greenwich mean time europe/helsinki eastern european time europe/isle of man greenwich mean time europe/istanbul eastern european time europe/jersey greenwich mean time europe/kaliningrad eastern european time europe/kiev eastern european time europe/lisbon western european time europe/ljubljana central european time europe/london greenwich mean time europe/luxembourg central european time europe/madrid central european time europe/malta central european time europe/mariehamn eastern european time europe/minsk eastern european time europe/monaco central european time europe/moscow moscow standard time europe/nicosia eastern european time europe/oslo central european time europe/paris central european time europe/podgorica central european time europe/prague central european time europe/riga eastern european time europe/rome central european time europe/samara samara time europe/san marino central european time europe/sarajevo central european time europe/simferopol eastern european time europe/skopje central european time europe/sofia eastern european time europe/stockholm central european time europe/tallinn eastern european time europe/tirane central european time europe/tiraspol eastern european time europe/uzhgorod eastern european time europe/vaduz central european time europe/vatican central european time europe/vienna central european time europe/vilnius eastern european time europe/volgograd volgograd time europe/warsaw central european time europe/zagreb central european time europe/zaporozhye eastern european time europe/zurich central european time indian/antananarivo eastern african time indian/chagos indian ocean territory time indian/christmas christmas island time indian/cocos cocos islands time indian/comoro eastern african time indian/kerguelen french southern & antarctic lands time indian/mahe seychelles time indian/maldives maldives time indian/mauritius mauritius time indian/mayotte eastern african time indian/reunion reunion time pacific/apia west samoa time pacific/auckland new zealand standard time pacific/chatham chatham standard time pacific/easter easter is time pacific/efate vanuatu time pacific/enderbury phoenix is time pacific/fakaofo tokelau time pacific/fiji fiji time pacific/funafuti tuvalu time pacific/galapagos galapagos time pacific/gambier gambier time pacific/guadalcanal solomon is time pacific/guam chamorro standard time pacific/honolulu hawaii standard time pacific/johnston hawaii standard time pacific/kiritimati line is time pacific/kosrae kosrae time pacific/kwajalein marshall islands time pacific/majuro marshall islands time pacific/marquesas marquesas time pacific/midway samoa standard time pacific/nauru nauru time pacific/niue niue time pacific/norfolk norfolk time pacific/noumea new caledonia time pacific/pago pago samoa standard time pacific/palau palau time pacific/pitcairn pitcairn standard time pacific/ponape ponape time pacific/port moresby papua new guinea time pacific/rarotonga cook is time pacific/saipan chamorro standard time pacific/samoa samoa standard time pacific/tahiti tahiti time pacific/tarawa gilbert is time pacific/tongatapu tonga time pacific/truk truk time pacific/wake wake time pacific/wallis wallis & futuna time pacific/yap truk time