Monthly Archives: July 2011

How to convert YYYYMMDDHHMMSS to Date/Time/Datetime in sql server

In this thread, i would like to show some SQL queries that converts YYYYMMDDHHMMSS style formatted date-string into Sql Server datetime format Method 1: The simplest method to achieve this would be using a stuff() function like it is shown … Continue reading

Posted in T-SQL | Tagged , , , , , , , , , | 1 Comment