Skip to Content.
Sympa Menu

freetds - Re: datetime format

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: datetime format
  • Date: Mon, 17 Dec 2001 14:55:44 -0800


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.

Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com




Archive powered by MHonArc 2.6.24.

Top of Page