ETL and Data Integration tools - Modern ETL software for everyone

Hi, Thanks,

We are currently evaluating your product (30 day trial) to possibly assist our analysts in pre-conversion of various source files for a data warehouse project. One source of data has a char field containing a date such as 2007112310345267 which I believe would be YYYYMMDDHHMMSSmm - this needs to be converted into a SQL Server date format such asMM/DD/YYYY HH:MM:SS am - how would can this be accomplished?

Thanks!!
Henry

I do not know which product you are talking about
We have 11 at the moment

Have a look at the documentation.

There is a charter dedicated to date formats

Mike