What formatting options are there for the timezone with qie.formatDate()?

Question

I need to format the TimeZone with a specific format for the receiving system.  How can I match the format they are expecting?

Answer 1

You can use the TimeZone formatting options that are listed on this question:

https://www.qvera.com/kb/index.php/755/where-documentation-format-strings-java-oracle-sqlserver

 

Specifically, the 'z', 'Z' and 'X'.

 

Here are examples of how they work:

 

Format	Result
yyyy-MM-dd'T'HH:mm:ss z	2015-06-08T14:32:33 MDT
yyyy-MM-dd'T'HH:mm:ss zzzz	2015-06-08T14:32:33 Mountain Daylight Time
yyyy-MM-dd'T'HH:mm:ssZ	2015-06-08T14:32:33-0600
yyyy-MM-dd'T'HH:mm:ssX	2015-06-08T14:32:33-06
yyyy-MM-dd'T'HH:mm:ssXX	2015-06-08T14:32:33-0600
yyyy-MM-dd'T'HH:mm:ssXXX	2015-06-08T14:32:33-06:00