Skip to Content.
Sympa Menu

freetds - Re: [freetds] Sybase DATE and TIME data types

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Sybase DATE and TIME data types
  • Date: Sun, 13 Sep 2015 10:55:47 +0100

2015-09-11 10:04 GMT+01:00 <matthew.green AT datamartcomputing.com>:
> Dear All,
>
> I'm not really a C programmer (or C++ for that matter) but I wanted to be
> able to use datacopy to copy tables with DATE and TIME data types. So, I
> decided to have a crack at adding them to FreeTDS.
>
> My testing has been successful, although I'm not sure the way I've coded it
> is correct so any help/fixes would be appreciated.
>
> I've attached a rich text document with the details. The first part
> proposes a quick and dirty fix, while the second is my best guess at the
> "correct" way of doing things.
>
> Bare in mind that this is currently only for Sybase to Sybase. I'm going to
> look at doing this for SQL Server too but that's a bit more complicated!
>
> Cheers,
>
> Matthew.
>


Patch and effort are really appreciated.
So appreciated that I already pushed some changes and is actually
testing deeply (but I don't think there will be any regression).

datacopy still does not work as SYBDATE/SYBTIME are not supported by
dblib (you added support for libTDS not upper libraries and datacopy
is based on dblib).

Currently converting from string will use datetime format in all
cases. ODBC has its standard so format strings are well defined for
it.

I added some improvements too based on previously patches on some other types.

Yes, adding a new type in FreeTDS is really a nightmare !!!

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page