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

Geoff Montee <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAA7biFO6DRvpVn-XG4C3B=xspvu-L4Xza-W12tmsaHCy=0UZUg@mail.gmail.com>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.