Basic idea of this article is to use of SQL server expression to convert and get date& time fromat.
SQL Server string to date / datetime conversion:

String date conversion (Without century (yy)): convert string to datetime

Convert string to date&time

Day (Mon) types are nondeterministic conversions:

SQL server datetime format (mon dd yyyy hh:mm:ss:mmmAM (or PM))

Date format (ISO) works international standard
