[freetds] FreeTDS and date format

Thompson, Bill D (London) bill_d_thompson at ml.com
Tue Sep 28 05:11:38 EDT 2004


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...


-----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


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 ?

Julien Ojéda

FreeTDS mailing list
FreeTDS at lists.ibiblio.org
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/ 

More information about the FreeTDS mailing list