Sorry about that.

For the date field the data type is date and the time field the data type is time. The destination has the field as datetime. So MessageDate is date and TradeDate is time(7)

I'm not sure how to provide the DDL. If you give me an example of a DDL I can provide it.