Skip to Content.
Sympa Menu

freetds - RE: [freetds] FreeTDS and date format

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] FreeTDS and date format
  • Date: Tue, 28 Sep 2004 10:11:38 +0100

Julien,

FreeTDS doesn't send dates to SQL server in any format!

The date format in locales.conf specifies the character format you wish to
see dates in when they are RETURNED from the server.

FreeTDS sends 'readable' SQL strings to SQL server, for example

update #mytable set christmas = '25/12/2004'

but the construction of that string is the responsibility of the application
that is calling FreeTDS...

Bill

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Julien Ojéda
Sent: 28 September 2004 09:41
To: freetds AT lists.ibiblio.org
Subject: [freetds] FreeTDS and date format


Hello,

I've a problem with the date format and freeTDS.
I'm french so the format I want to use is dd/mm/yyyy but FreeTDS always send
date to the MS-SQL Server interpreted in the english format mm/dd/yyyy. So
when I want to record 14/11/2004 it fails.
I add french [fr_FR] and date format = %d %b %Y %H:%M in locales.conf and I
used setlocale(LC_TIME,'fr_FR'); in my scripts but It still doesn't work.

Does someone have any idea ?

Thanks.
Julien Ojéda

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------





Archive powered by MHonArc 2.6.24.

Top of Page