freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Get rid of milliseconds from MS SQL server
- From: Patrick Gu <Patrick.Gu AT Ticketmaster.com>
- To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Get rid of milliseconds from MS SQL server
- Date: Fri, 30 Sep 2005 14:49:19 -0700
Fred,
Thanks, that's what I thought and I will make the conversion in the SQL
Server.
-Patrick
-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
Sent: Friday, September 30, 2005 12:27 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Get rid of milliseconds from MS SQL server
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.
freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-
[freetds] Get rid of milliseconds from MS SQL server,
Patrick Gu, 09/30/2005
- Re: [freetds] Get rid of milliseconds from MS SQL server, Frediano Ziglio, 09/30/2005
- Re: [freetds] Get rid of milliseconds from MS SQL server, David Chang, 09/30/2005
- <Possible follow-up(s)>
- Re: [freetds] Get rid of milliseconds from MS SQL server, Patrick Gu, 09/30/2005
Archive powered by MHonArc 2.6.24.