Skip to Content.
Sympa Menu

freetds - [freetds] Sybase DATE and TIME data types

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: matthew.green AT datamartcomputing.com
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Sybase DATE and TIME data types
  • Date: Fri, 11 Sep 2015 09:04:58 +0000

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.

Attachment: Getting datacopy to correctly copy date and time data.rtf
Description: RTF file




Archive powered by MHonArc 2.6.24.

Top of Page