Posted by --CELKO-- on 11/02/06 15:15

>> but I don't know what to do with the "datetime year to month" Informix datatype, I mean, I dn't know why the DTS changes this datatype to "smalldatetime". <<

SQL Server only has waht woudl be a TIMESTAMP in Standard SQL. I would
consider using a pair of DATETIME columns (start of month, end of
month) to mimic the Informix type.

• Next in forum: Re: Create and then USE a dynamically-named database?
• Prev in forum: Re: Tricky group by date problem
• Thread view: Re: Trouble with Informix datatypes

[Reply to this message]