FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Shawn,

If you want to play around with different formats within the same session,
you will have to do it within your SQL, using CONVERT()

each of the API's (dblib, ctlib and ODBC) have different default date
representations when converting dates to strings.
A date format entry in locales.conf for your locale will override these
defaults in all cases and impose the date format specified.

Bill

> -----Original Message-----
> From: Shawn Greene [SMTP:sgreene AT azorus.com]
> Sent: 29 January 2003 15:20
> To:   freetds AT lists.ibiblio.org
> Subject:      [freetds] Supported date time formats
> 
> Hello,
> 
> I want to update my locales.conf file to support 
> many date formats within my queries.. 
> 
> #1 is this possible
> #2 does anyone have an example?
> 
> BTW.. I am running FreeBSD 4 with FreeTDS 6.1 
> using Sybase libs to connect to a MSSQL 2k DB.
> 
> Any help would be appreciated!
> 
> Thanks,
> 
> Shawn
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds