To remain competitive your organisation must be efficient across the business process spectrum. To do so you need to take sound decisions based on a balance between the cost and risk. To do so you will be heavily dependent on your content management in itself needs...
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: