<div>
The substring is still not converted to a date.<br />
<br />
I get this message: <br />
Conversion failed when converting date and/or time from character string.
</div>


The substring is still not converted to a date.

I get this message:
Conversion failed when converting date and/or time from character string.

<div>
Thanks for pointing me in the right direction. I've figured it out.
</div>


Thanks for pointing me in the right direction. I've figured it out.

<div>
What was the problem?<br />
(I did actually test what I proposed and it worked without issue)
</div>


What was the problem?
(I did actually test what I proposed and it worked without issue)

<div>
<div class="content wysiwyg-content">
SQL Server 2008. <br />
I have a file name that contains date information that I need to load into a date field. To get the date information I'm using a substring. I am not able to convert the substring to a date, please help.<br />
<br />
File Name: XXXX_XXXXRN_FLAT10_XXX_201<wbr />31230_0731<wbr />.DAT<br />
<br />
substring: SUBSTRING(FILE_NM,24,4)+'-<wbr />'+SUBSTRIN<wbr />G(FILE_NM,<wbr />28,2)+'-'+<wbr />SUBSTRING(<wbr />FILE_NM,30<wbr />,2)+' 00:00:00.000' <br />
<br />
Returns: 2013-12-30 00:00:00.000<br />
<br />
I am not able to update the 2013-12-30 00:00:00.000 to a date field. I have tried CAST and CONVERT on the substring with no luck.
</div>
</div>


SQL Server 2008. 
I have a file name that contains date information that I need to load into a date field. To get the date information I'm using a substring. I am not able to convert the substring to a date, please help.

File Name: XXXX_XXXXRN_FLAT10_XXX_20131230_0731.DAT

substring: SUBSTRING(FILE_NM,24,4)+'-'+SUBSTRING(FILE_NM,28,2)+'-'+SUBSTRING(FILE_NM,30,2)+' 00:00:00.000' 

Returns: 2013-12-30 00:00:00.000

I am not able to update the 2013-12-30 00:00:00.000 to a date field. I have tried CAST and CONVERT on the substring with no luck.

SQL Serving converting substring to date

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.