Discussion:
[freetds] FreeTDS dates different between versions
Nick Walke
2013-05-02 21:37:24 UTC
Permalink
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
Thomas, Christopher (LLU)
2013-05-03 00:26:00 UTC
Permalink
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: freetds-bounces at lists.ibiblio.org [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Nick Walke
Sent: Thursday, May 02, 2013 2:37 PM
To: freetds at lists.ibiblio.org
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
Nick Walke
2013-05-03 00:46:31 UTC
Permalink
I checked that too. The freetds.conf file is the same on both.
On May 2, 2013 7:31 PM, "Thomas, Christopher (LLU)" <cwthomas at llu.edu>
Post by Thomas, Christopher (LLU)
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-----
freetds-bounces at lists.ibiblio.org] On Behalf Of Nick Walke
Sent: Thursday, May 02, 2013 2:37 PM
To: freetds at lists.ibiblio.org
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
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Nick Walke
2013-05-03 13:46:57 UTC
Permalink
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
Post by Nick Walke
I checked that too. The freetds.conf file is the same on both.
On May 2, 2013 7:31 PM, "Thomas, Christopher (LLU)" <cwthomas at llu.edu>
Post by Thomas, Christopher (LLU)
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-----
freetds-bounces at lists.ibiblio.org] On Behalf Of Nick Walke
Sent: Thursday, May 02, 2013 2:37 PM
To: freetds at lists.ibiblio.org
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
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Frediano Ziglio
2013-05-03 20:05:23 UTC
Permalink
Which library are you using? dblic, ctlib or odbc ?

Frediano


2013/5/3 Nick Walke <tubaguy50035 at gmail.com>
Post by Nick Walke
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
Post by Nick Walke
I checked that too. The freetds.conf file is the same on both.
On May 2, 2013 7:31 PM, "Thomas, Christopher (LLU)" <cwthomas at llu.edu>
Post by Thomas, Christopher (LLU)
The protocol version might be different on the newer install. Look at
the
Post by Nick Walke
Post by Thomas, Christopher (LLU)
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-----
freetds-bounces at lists.ibiblio.org] On Behalf Of Nick Walke
Sent: Thursday, May 02, 2013 2:37 PM
To: freetds at lists.ibiblio.org
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
Post by Nick Walke
Post by Thomas, Christopher (LLU)
do on the new server to get it to return dates like on version 0.82?
The
Post by Nick Walke
Post by Thomas, Christopher (LLU)
servers are running different OSes if that makes a difference as well.
Nick
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Loading...