Bug: not forcing period as decimal point on european computers

[James Powell]

Was using

%^<%Y-%m-%dT%H:%M:%S.;%3uZ>T

the .; was accepted (not printed and no error) yet it appears to do nothing.

Actual format needs to be

%.;%^<%Y-%m-%dT%H:%M:%S%3uZ>T

with %.; as a separate item at front.

[James Powell]

Note: Timestamps with a comma will cause error in the SQLite datetime() function, but one can take only the first 20 characters, which excludes the fractional second:

datetime(substr(MyTime,0,20))

‌

[James Powell]

Also note: functions that read the timestamp can handle the comma, even though it is not as per RFC3339 spec.

[James Powell]

in v 1.2.2

[James Powell]

https://bitbucket.org/drjdpowell/jdp-science-common-utilities/commits/a80052c3c632dca7162b5b2a7b1df6b11f1b2299

[James Powell]

This also seems to work work (adding a % character before the .;)

%^<%Y-%m-%dT%H:%M:%S%.;%3uZ>T

‌