[freetds] FreeTDS and date format

Julien Ojéda julien.ojeda at logicielnet.com
Tue Sep 28 05:21:01 EDT 2004


Thank you,

So I don't understand what is my problem :
My application worked well with a server using an older version of FreeTDS
but we just put the application on a new server with FreeTDS 0.61 and it
doesn't work.

Do you think the problem may came from PHP's configuration on the new server
?

Thanks again.

----- Original Message ----- 
From: "Thompson, Bill D (London)" <bill_d_thompson at ml.com>
To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
Sent: Tuesday, September 28, 2004 11:11 AM
Subject: RE: [freetds] FreeTDS and date format


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

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





More information about the FreeTDS mailing list