FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Robert Benjamin wrote:
> James K. Lowden wrote:
> > Robert Benjamin wrote:
> > 
> >>Also, when I print out the date modified, I get a result like "Jul 19 
> >>2005 10:50:54:813AM". The locales.conf has for the date format "date 
> >>format = %b %d %Y %I:%M%p" 
> >
> > Could it be something trivial, as in locales.conf is not being read
> > because it's in the wrong directory?  
> 
> It looks like it was a mis-install on our system. The problem stemmed 
> from either one of two things: 1. About a month ago I installed version 
> 0.63 of freetds in the wrong place and, realizing my mistake, I 
> re-configured and re-installed in the correct place but I neglected to 
> clean up the files and libraries in the incorrect install directories. 
> 2. There were some old lib files in the freetds/lib directory (such as 
> libtds.so.3.0) that were not removed on new installs.
...
> I figured this out by noticing that changes to the locales.conf were not
> 
> being reflected in the output.

Excellent.  Archive readers may wish to note that db-lib datetime output
conversion can be easily tested with bsqldb:

$ echo "SELECT [DateModified] FROM PEOPLE WHERE LastName LIKE '%Smith%'" \
  | bsqldb -S [etc.]

I'm sorry I didn't suggest that first.  

--jkl