Re: FreeTDS dates different between versions

Which library are you using? dblic, ctlib or odbc ?

Frediano


2013/5/3 Nick Walke <[email protected]>

> 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
> >>
> >
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>