Re: FreeTDS dates different between versions
"Thomas, Christopher (LLU)" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <D5C071CD696CB34EAE2B70DD5567F4C00793C1@LLUDBS2.llu.ad.lluahsc.org> |
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