Page 1 of 1
Question about datatypes
Posted: Fri Nov 11, 2005 1:19 am
by Sunetrika
What should be the datatype used if the single column is having both date & time data as a source
Posted: Fri Nov 11, 2005 2:21 am
by loveojha2
Use Timestamp(19)
Posted: Sat Nov 12, 2005 1:50 pm
by kcbland
Depends on the source stage you are using. Some databases store date + time under DATE data type, like Oracle. Therefore, the metadata should be DATE.
How about you import the metadata, which DS reads from the data source and stores in the Manager library? Then you don't have to know what the metadata is, DS will understand it itself.