Skip to Content.
Sympa Menu

freetds - Re: datetime format

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Steve Langasek <vorlon AT netexpress.net>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: datetime format
  • Date: Tue, 18 Dec 2001 16:35:13 -0600

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




Archive powered by MHonArc 2.6.24.

Top of Page