[freetds] Out-of-the-box "date format" values for "default" and "en_US" locales

Frediano Ziglio freddy77 at gmail.com
Mon Apr 13 11:39:34 EDT 2015


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?
>
> Thanks,
>
> Geoff Montee
>

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.

Frediano


More information about the FreeTDS mailing list