FreeTDS Development Group

[Steve Langasek <vorlon AT netexpress.net>]

On Mon, Dec 17, 2001 at 02:55:44PM -0800, Michael Peppler wrote:
> James Cameron writes:
>  > "Winkless, Geoff" wrote:
>  > > You may find that you need to put
>  > > SET DATEFORMAT YMD

>  > According to documentation, this only affects date input to the SQL
>  > server, not SELECT output.

> Absolutely - and this is true for Sybase as well.

> Default datetime format can be modified (in the client) via changes to
> the locales files (for Client Library) (see the [datetime] section of
> the locales/us_english/iso_1/common.loc file which has the details).

> This information is then used in the default CS_LOCALE structure that
> is used to define client side data conversions.

> I'm not sure how much of all this FreeTDS supports at this point,
> though. 

I don't think FreeTDS currently has any support for selection of
datetime formats through client locale settings, but I definitely agree
that this (what Sybase did) is the right way to implement such a creature...

Steve Langasek
postmodern programmer

Attachment: pgpTRg4ZOhKdt.pgp
Description: PGP signature