|
|
Posted by louisyoung187@hotmail.com on 11/02/06 07:04
> as you can see the float and datetime year to month data types change
> like the example before.... I changed the "float" datatype manually to
> "decimal" datatype... 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"... how can I map this? what's
> the process?
Well, there is no "datetime YEAR to MONTH" datatype in MS SQL Server,
so what I can suggest is that you use the datetime data type. As for
the formatting, this does not get stored in SQL Server, but you'll need
to do the formatting when you retrieve the data.
Hope this helps
Louis
Navigation:
[Reply to this message]
|