<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a SQL table where a date file is in String Format ( e.g. 09-Aug-2017).<br />
I want to use this field as a date field in SQL. How can I convert this to Date?<br />
<br />
Regards<br />
<br />
Gerry
</div>
</div>


Hi

I have a SQL table where a date file is in String Format ( e.g. 09-Aug-2017).
I want to use this field as a date field in SQL. How can I convert this to Date?

Regards

Gerry

SQL Convert String to date format

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.