Skip to Content.
Sympa Menu

freetds - [freetds] Get rid of milliseconds from MS SQL server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Patrick Gu <Patrick.Gu AT Ticketmaster.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Get rid of milliseconds from MS SQL server
  • Date: Fri, 30 Sep 2005 10:48:06 -0700

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!

-Patrick




Archive powered by MHonArc 2.6.24.

Top of Page