[freetds] Get rid of milliseconds from MS SQL server

David Chang dchang at fsautomation.com
Fri Sep 30 18:01:51 EDT 2005


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
>



More information about the FreeTDS mailing list