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
