Australian Time Zones

[David Reiser]

The OFX spec gives an example:

“20051005132200.124[-5:EST]” represents October 5, 2005, at 1:22 and 124 milliseconds p.m., in Eastern Standard Time. This is the same as 6:22 p.m. Greenwich Mean Time (GMT).

If no offset is given, the time should be considered GMT (including 12:00am if no time is given). But I don’t have a lot of faith that all banks are paying attention to that.

The spec also says that you can omit fields from the right, and that if transactions are only available daily, then dates without times will work correctly. And:
"Note: Open Financial Exchange does not require servers or clients to use the full precision specified. However, they are REQUIRED to accept any of these forms without complaint."


--
Dave Reiser
dbreiser at icloud.com





> On Dec 19, 2016, at 7:51 PM, GWB <gwb at 2realms.com> wrote:
> 
> Just out of curiosity, what exactly is the expected format of the DT
> fields in ofx and qfx?  Looking at a downloaded bank .qfx file in the
> US, I see fields like:
> 
> <DTSERVER>20161025190928.238
> 
> <DTPROFUP>20050531050000.000
> 
> <DTPOSTED>20160701120000.000
> 
> But nowhere in the file do I see anything like utc+/- or gmt+/-.  Are
> these already in UTC+/-0?  I'm also used to solaris and bsd time
> designations, but as a general rule, I rather work with gmt 0 if
> anything has to be converted.  I tend to go by post date when
> downloading a quarter of transactions, because the transaction date
> from institutions like Chase don't match the actual date and time of
> the physical transaction (I don't expect it to, because the bank often
> gets "batch" transactions at one time of the day, sometimes for
> transactions over several days).
> 
> And as an aside, God Bless those parts of Australia that do not let
> Standard Time or Daylight Savings Time push them around.  DST is just
> plain evil.  Why should solar noon ever be earlier than 11:30 or later
> than 12:30?  It violates the laws of nature.
> 
> Gordon
> 
> On Mon, Dec 19, 2016 at 6:11 PM, Chris Good <chris.good at ozemail.com.au> wrote:
>>> Message: 12
>>> Date: Mon, 19 Dec 2016 06:57:52 -0800
>>> From: John Ralls <jralls at ceridwen.us>
>>> To: Doug Laidlaw <laidlaws at hotkey.net.au>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: Australian Time Zones
>>> Message-ID: <F90AA4E0-B1B1-4A03-A1EE-F271B7F599DC at ceridwen.us>
>>> Content-Type: text/plain; charset=us-ascii
>>> 
>>> 
>>>> On Dec 18, 2016, at 11:20 PM, Doug Laidlaw <laidlaws at hotkey.net.au>
>>> wrote:
>>>> 
>>>> The recent release notes gave Australia's timezone as GMT-10.  That is
>>>> not correct.
>>>> 
>>>> Australia has three timezones.  In Eastern Australia, where I live, the
>>>> timezone is GMT+10 (150 deg E.)  Summer time, where implemented, is
>>>> GMT+11.
>>>> 
>>>> Central time, used in Adelaide, is GMT+9.5.
>>>> 
>>>> Perth, W.A. time is GMT+8.  East of Eucla on the south coast, local
>>>> time is GMT+9, but that may not be an official TZ.
>>>> 
>>>> GMT-10 passes right through Central Alaska, but Alaska uses GMT-9.
>>>> 
>>> 
>>> No, the release note reports a bug titled "Australian (GMT-10) OFX
>>> transactions imported have previous day's date." as being fixed. That bug
>>> was filed by someone in the GMT+10 TZ and he included that information in
>>> the title, but got the sign wrong.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>> 
>> That some-one was me and I referred to it that way because I'm used to
>> setting TZ in Solaris or AIX like
>> TZ="EST-10EDT-11,M10.1.0,M4.1.0"
>> 
>> Thanks for 2.6.15 everyone :-)
>> 
>> Regards, Chris Good
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.