vorlon at netexpress.net
Tue Dec 18 17:35:13 EST 2001
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,
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...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 232 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20011218/18c406c1/attachment.bin
More information about the FreeTDS