datetime format

Steve Langasek 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,
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20011218/18c406c1/attachment.bin 


More information about the FreeTDS mailing list