sql server 2008 - Parse a string into a date in SQL -


i have string field format jan/17 - there way convert date? using cast fails conversion. 12 months in 3 character format.

this appears work:

select cast('01/' + col date) 

Comments

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

ios - Change Storyboard View using Seague -