Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "David Chang" <dchang AT fsautomation.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 15:01:51 -0700

I don't know about freetds, but Transact-SQL has the 'convert' function.

Instead of writing:

select end_date from table_A where end_date > '01/01/2005'

you could write

select convert(char(30), end_date, 100) from table_A where end_date >
'01/01/2005'

Here are the convert values other than '100':

Without
century
(yy) With
century
(yyyy)

Standard

Input/Output**
- 0 or 100 (*) Default mon dd yyyy hh:miAM (or PM)
1 101 USA mm/dd/yy
2 102 ANSI yy.mm.dd
3 103 British/French dd/mm/yy
4 104 German dd.mm.yy
5 105 Italian dd-mm-yy
6 106 - dd mon yy
7 107 - mon dd, yy
8 108 - hh:mm:ss
- 9 or 109 (*) Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or
PM)
10 110 USA mm-dd-yy
11 111 JAPAN yy/mm/dd
12 112 ISO yymmdd
- 13 or 113 (*) Europe default + milliseconds dd mon yyyy
hh:mm:ss:mmm(24h)
14 114 - hh:mi:ss:mmm(24h)
- 20 or 120 (*) ODBC canonical yyyy-mm-dd hh:mi:ss(24h)
- 21 or 121 (*) ODBC canonical (with milliseconds) yyyy-mm-dd
hh:mi:ss.mmm(24h)
* The default values (style 0 or 100, 9 or 109, 13 or 113, 20 or
120, and 21 or 121) always return the century (yyyy).
** Input when converting to datetime; Output when converting to
character data.



I got this out of MS SQL Server books online.

DC

----- Original Message -----
From: "Patrick Gu" <Patrick.Gu AT Ticketmaster.com>
To: <freetds AT lists.ibiblio.org>
Sent: Friday, September 30, 2005 10:48 AM
Subject: [freetds] Get rid of milliseconds from MS SQL server


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





Archive powered by MHonArc 2.6.24.

Top of Page