<div>
Might be better ways but this is what I came up with off the top of my head:<br />

<pre><code class="code-1 nolinks" id="code-20-43306334-1"><span>convert(varchar, cast(left(creationdate ,charindex('-',creationdate)-1) as date),103)</span>
</code></pre>
</div>


Sam OZ

<div>
No need to search for the dash, it is a fixed format:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-43306345-1"><span>DECLARE @Sample NVARCHAR(255) = N'2019/02/21-03:02:32:051';</span>
<span></span>
<span>SELECT PARSE(LEFT(@Sample, 10) AS DATE),</span>
<span>       CONVERT(DATE, LEFT(@Sample, 10), 111);</span>
<span></span>
<span>DBCC USEROPTIONS;</span>
</code></pre>
<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w26/1564377/Capture.PNG" target="_blank" title="Capture.PNG (12 KB)"><img alt="Capture.PNG" class="file-block lazyload" style="max-width: 321px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w26/1564377/Capture.PNG" /></a>
</div>


Capture.PNG

Co-Founder and Chief Architect

Dustin Saunders

<div>
&gt;&gt;No need to search for the dash, it is a fixed format<br />
<br />
DUH.... &nbsp; ;) &nbsp;old habits.......
</div>


<div>
As the input is nvarchar I suggest you use <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/try-convert-transact-sql?view=sql-server-ver15" rel="ugc">TRY_CONVERT()</a> instead of CONVERT as this is fault tolerant and returns NULL if the input cannot be converted to date.<br><br>e.g. this will still run without error even with an invalid date<br><pre><code class="code-1 nolinks" id="code-20-43308996-1"><span>DECLARE @Sample NVARCHAR(255) = N'2019/02/30-03:02:32:051';</span>
<span></span>
<span>SELECT</span>
<span>&nbsp; &nbsp; &nbsp; TRY_CONVERT(DATE, LEFT(@Sample, 10), 103)</span>
<span>;</span>
</code></pre>(it returns NULL instead of crashing the query)<br><br>&amp; style 103 is dd/mm/yyyy<br><br>see:&nbsp;<a href="https://www.experts-exchange.com/articles/12315/SQL-Server-Date-Styles-formats-using-CONVERT.html" rel="ugc">https://www.experts-exchange.com/articles/12315/SQL-Server-Date-Styles-formats-using-CONVERT.html</a>
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have an Sql server 2016 table TB_Doc where the field creationdate is a varchar field<br>sample value : &nbsp;2019/02/21-03:02:32:051<br>I am looking for an sql query to get the dd/mm/yyyy &nbsp;value out of it <br>for example in this case I should get&nbsp; 21/02/2019&nbsp;
</div>
</div>



I have an Sql server 2016 table TB_Doc where the field creationdate is a varchar field
sample value :  2019/02/21-03:02:32:051
I am looking for an sql query to get the dd/mm/yyyy  value out of it
for example in this case I should get  21/02/2019 

Sql server query to convert date

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

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.