Introduction to ETL lightning

2006-12-20
The Excel file in the source file cannot be written into a combination of letters when the data is listed. The date format contains "Noon, when the source file is used as an Excel worksheet, modify these columns ('A' is added to the source column '). Then, when the reverse SQL statement is executed, the excess parts of these columns are removed.

The procedure is as follows:

Declare @ A varchar (30)
Set @ A = '2017/30 09:20:07 am'
Select
Case
When @ A like '% am %' then convert (datetime, replace (@ A, 'am ', '') + 'am ')
When @ A like '%' then convert (datetime, replace (@ A, 'Afternoon ', '') + 'ps ')
End as 'tt'