Datetime and Timestamp

snassimr · Post by **snassimr** » Tue Jun 14, 2005 6:59 am

Hi !

I use datetime type in SQL Server and in DS it defined as timestamp.
When i bring char that I used eirlier for smalldate time I get warning :

results of SQLColAttributes(CustBrthdate) gave MetaData mismatch
COLUMN.TYPE Expected = Timestamp Actual = Char

Any ideas ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jun 14, 2005 7:08 am

I think smalldatetime is the datetime within a restricted period.

You need to supply the default timestamp format.

Check whether the column is a timestamp and also whether you are doing a cast in it.

snassimr · Post by **snassimr** » Tue Jun 14, 2005 7:45 am

How I can to do cast ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jun 14, 2005 10:07 am

You need not do a 'cast'. You can do a select with the datatype in datastage being timestamp.

But can you confirm that the column you try to select is a timestamp.

snassimr · Post by **snassimr** » Tue Jun 14, 2005 12:55 pm

Yes . I see in DS that the column defined as Timestamp (Length - 23 , Scale 3) .

I build the Timestamp in format yyyy/mm/dd hh:nn:ss but it still doesnt work. I see that DS doesnt conveert it before entering it to target table as it happens with smalldatetime case

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jun 14, 2005 12:58 pm

You need a '.000' in the end for milli-seconds.