freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales
- From: Fredy Paquet <fredy AT opag.ch>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>, <geoff.montee AT gmail.com>
- Subject: Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales
- Date: Tue, 14 Apr 2015 08:46:52 +0200 (CEST)
Hello Geoff
Beware that %z ist not supported by sprintf() on Win32
--
Fredy Paquet
OPAG Informatik AG
Fabrikmattenweg 11
CH-4144 Arlesheim
Tel. 0041 61 7169222
Fax. 0041 61 7169229
http://www.opag.ch
Am 14. April 2015, 1:30, schrieb Geoff Montee:
Hi Frediano,
On Mon, Apr 13, 2015 at 8:39 AM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
Il 09/Apr/2015 18:40, "Geoff Montee" <geoff.montee AT gmail.com> ha scritto:
In FreeTDS, the "default" and "en_US" locales have the following values of
"date format" defined in locales.conf:
[default]
date format = %b %e %Y %I:%M:%S:%z%p
[en_US]
date format = %b %e %Y %I:%M:%S:%z%p
language = us_english
charset = iso_1
Is there a reason that FreeTDS chose to separate the seconds and
milliseconds with a colon (':'), rather than a dot ('.')? A few users of
tds_fdw recently ran into issues with this:
https://github.com/GeoffMontee/tds_fdw/issues/13
Because of the ISO 8601 standard, I think most applications expect a dot
separator between seconds and milliseconds.
http://en.wikipedia.org/wiki/ISO_8601
These days, it may make sense to use ISO 8601 as the default "date
format",
since it is pretty universal. If FreeTDS is going to have a new release
soon, maybe it would be worth changing the default date format?
I don't remember the history but must be quite old.
Yes, default can change. As long is well documented I don't see the point
keeping the colon.
Thanks for the reply!
Changing the colon to a dot sounds good to me.
Would it be worth changing the default completely to an ISO
8601-compatible format? That would probably be something like:
[default]
date format = %Y-%m-%dT%H:%M:%S.%z
The main difference between that and ISO-8601 is that it wouldn't
contain the timezone offset. strftime uses %z for the timezone offset,
but FreeTDS uses %z for the milliseconds.
Thanks,
Geoff
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature
-
[freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Geoff Montee, 04/09/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Frediano Ziglio, 04/13/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Geoff Montee, 04/13/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Fredy Paquet, 04/14/2015
- Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales, Frediano Ziglio, 04/14/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Fredy Paquet, 04/14/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
matthew . green, 04/14/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Geoff Montee, 04/15/2015
- Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales, Jeffrey Shaw, 04/15/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
matthew . green, 04/16/2015
- Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales, Frediano Ziglio, 04/17/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Geoff Montee, 04/15/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Geoff Montee, 04/13/2015
-
Re: [freetds] Out-of-the-box "date format" values for "default" and "en_US" locales,
Frediano Ziglio, 04/13/2015
Archive powered by MHonArc 2.6.24.