• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 47
  • Last Modified:

SQL Convert String to date format

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
0
gmollineau
Asked:
gmollineau
1 Solution
 
NorieVBA ExpertCommented:
Gerry

If this is SQL Server you can use CONVERT.

CONVERT(datetime, yourtextdatefield)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now