Re: Sybase DATE and TIME data types
Matthew <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Thanks for the kind words. It seems I must have missed something as datacopy is working for me when copying DATE and TIME columns from ASE 15.7 to ASE 15.7. A lot of what I did was trial and error and I tried to remember to leave a comment so I could find what I'd changed in order to write it up at the end. Any idea which file I would have changed to get it working with dblib? If not I'll untar the package somewhere else and run a find and diff to see if I can spot it. Cheers, Matthew. On 13/09/15 11:55, Frediano Ziglio wrote: > 2015-09-11 10:04 GMT+01:00 <[email protected]>: >> 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 > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds