Time zones in parse date time

5
What time zones supports parse date time. [EDIT] Some additional information to make the question more clear: When parsing a date/time string that includes a timezone in a microflow (using parseDateTime($dateTime, 'yyyy-MM-dd HH:mm:ss Z')), what are the valid timezone codes? Since Mendix runs on Java, I assumed this would be the list as returned by java.util.TimeZone.getAvailableIDs(), but after testing this doesn't seem to be the case.
asked
3 answers
7

SimpleDateformat defines what patterns are allowed for parseDateTime(). The number of characters define what kind of form is used. Up to 3 characters is the short/abbreviated form, 4 and more is the full form.

E.g.:

"yyyy.MM.dd G 'at' HH:mm:ss z" : 2001.07.04 AD at 12:08:56 PDT

"hh 'o''clock' a, zzzz" : 12 o'clock PM, Pacific Daylight Time

"yyyy-MM-dd'T'HH:mm:ss.SSSZ" : 2001-07-04T12:08:56.235-0700

answered
2
DateFormat dateFormat = new SimpleDateFormat("yyy-MM-dd HH:mm:ss Z");
    String orig = "2010-07-01 13:15:00 ";
    int i = 0;
    for (String s : dateFormat.getTimeZone().getAvailableIDs()) {
        try {
            dateFormat.parse(orig + s);
            System.out.println(s);
        }
        catch (Exception e) {}
    }

gives:

HST AST PST PST8PDT MST MST7MDT CST CST6CDT EST EST5EDT GMT GMT0 UTC WET CET ECT MET ART CAT EET EAT IST BST JST SST NST

answered
1

Which time zones are supported? For the time zones ACT and AET the parse date time does not work.

answered