Question about datatypes

Sunetrika · Post by **Sunetrika** » Fri Nov 11, 2005 1:19 am

What should be the datatype used if the single column is having both date & time data as a source

loveojha2 · Post by **loveojha2** » Fri Nov 11, 2005 2:21 am

Use Timestamp(19)

kcbland · Post by **kcbland** » Sat Nov 12, 2005 1:50 pm

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.