[freetds] Get rid of milliseconds from MS SQL server

James K. Lowden jklowden at freetds.org
Sat Oct 1 09:47:31 EDT 2005


Frediano Ziglio wrote:
> Il giorno ven, 30/09/2005 alle 10.48 -0700, Patrick Gu ha scritto:
> > Hi,
> > 
> > I am using freetds 0.63 with DBD::ODBC to pull data from MS SQL Server
> > 2000 to RH AS3. But I am getting the milliseconds for the date columns
> > in the format of
> > YYYY-MM-DD HH:MI:SS.SSS, anyone know if there is a quick way in
> > freetds or DBD::ODBC to set the format?
> > 
> > Thanks!
> > 
> 
> Well... it depends. If server return (SMALL)DATETIME column FreeTDS
> format it to ODBC format (the same you reported) if column is converted
> by mssql you should check mssql documentation (tsql, cast, convert, set
> dateformat...). I don't know if DBD::ODBC have options to set date
> format for DATETIME... MS ODBC driver have an option to use system
> setting to format data as system settings; FreeTDS don't have such
> option for simplicity, and it do not even support precision setting on
> date.

Isn't this what the "date format" in locales.conf takes care of?  

--jkl


More information about the FreeTDS mailing list