Page 1 of 1

Data type interpretation and manipulation

Posted: Thu May 31, 2007 5:38 am
by Ragunathan Gunasekaran
i have a month to date field which is assisgned a metadata "Number(5)" in datastage . I would like to add this to a field assigned a metadata "Date" in datastage . I dont understand whats a "month to date " data ? how this data would be wrt to the metadata that i have given


I have some ODBC issues reported when i try to view the data from the stage but before that can somebody give me some idea about what the month to date data would look like ? ? ?

Posted: Thu May 31, 2007 6:36 am
by chulett
Source database? Actual data type? :?

Is this some kind of INTERVAL data type?

Data type interpretation and manipulation

Posted: Thu May 31, 2007 9:27 am
by Ragunathan Gunasekaran
The source database is SQL server database The source datatype is SQL server date datatype