converting string format to date format

Question

I am not able to convert the string to DATE format

select CONVERT(DATE, '8/17/2016', 103)

Conversion failed when converting date and/or time from character string.

what can we do to resolve this thanks

Are you using MySQL or MS SQL Server? (Don't tag products not involved.) — jarlh
– jarlh, Commented Nov 22, 2016 at 12:59

Pரதீப் · Accepted Answer · 2016-11-22 13:03:07Z

1

Actually you don't need that style, It is the one causing the error. Just CAST/CONVERT it to date. Try this

select CONVERT(DATE, '8/17/2016')

answered Nov 22, 2016 at 13:03

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tharunkumar Reddy · Accepted Answer · 2016-11-22 13:03:53Z

1

You can try with cast also

  select cast( '8/17/2016' as date)

answered Nov 22, 2016 at 13:03

Tharunkumar Reddy

2,81320 silver badges33 bronze badges

Comments

Mansoor · Accepted Answer · 2016-11-22 13:01:17Z

0

SELECT CONVERT(DATE, '8/17/2016', 101)

answered Nov 22, 2016 at 13:01

Mansoor

4,1921 gold badge19 silver badges27 bronze badges

1 Comment

Alessandro Cuttin Over a year ago

please, consider adding an explanation, even a short one. Thanks!

Chanukya · Accepted Answer · 2016-11-22 13:01:48Z

0

SELECT convert(datetime, '8/17/2016', 111)

answered Nov 22, 2016 at 13:01

Chanukya

5,8911 gold badge24 silver badges39 bronze badges

1 Comment

Alessandro Cuttin Over a year ago

please consider adding an explanation, even a short one. Thanks!

Collectives™ on Stack Overflow

converting string format to date format

4 Answers 4

Comments

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related