Re: FreeTDS dates different between versions
Nick Walke <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAJiKK9g7eNEEX=fJQp+5E17QUyZMFRxk8n6tNizCXwPXBJ3qiQ@mail.gmail.com> |
The locales files on the old server actually didn't have the date format it was using. I tried changing the date formats in the locales file on the new server to what I want it to be, but with no success either. Nick On Thu, May 2, 2013 at 7:46 PM, Nick Walke <[email protected]> wrote: > I checked that too. The freetds.conf file is the same on both. > On May 2, 2013 7:31 PM, "Thomas, Christopher (LLU)" <[email protected]> > wrote: > >> The protocol version might be different on the newer install. Look at the >> protocol version (called 'tds version') defined in the old >> /etc/freetds.conf and make sure it is the same on the newer one. >> >> -----Original Message----- >> From: [email protected] [mailto: >> [email protected]] On Behalf Of Nick Walke >> Sent: Thursday, May 02, 2013 2:37 PM >> To: [email protected] >> Subject: [freetds] FreeTDS dates different between versions >> >> We're rebuilding a web server that uses FreeTDS to connect to an MSSQL >> server. The old server is running FreeTDS 0.82 and the new server is >> running version 0.91. The date formatting seems to be off on the new >> server. When retrieving dates, they come back as something like "Feb 19 >> 2013 12:00:00:000AM". The old server would return them like "2013-04-01 >> 00:00:00". I've verified that the locale files are the same. What can I >> do on the new server to get it to return dates like on version 0.82? The >> servers are running different OSes if that makes a difference as well. >> >> Nick >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> >