How to change this date format of this '13/11/2017'

Question

Msg 242, Level 16, State 3, Line 1 The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Show the code that is generating the error. – Gordon Linoff Jun 13 '17 at 11:52 — Gordon Linoff, Jun 13 '17 at 11:52

score 2 · Accepted Answer · answered Jun 13 '17 at 11:54

2

By default it normally will be yyyy-mm-dd so you might require to provide explicit type as below:

Select convert(date, '13/11/2017',103)

answered Jun 13 '17 at 11:54

Kannan Kandasamy

score 0 · Answer 2 · answered Jun 13 '17 at 12:02

You souhld check the style parameter.

convert(data_type, expression, stlye)

In your case:

convert(date, '13/11/2017',103)

Most popular date conversions:

convert(date, 'dd/mm/yyyy', 103)

convert(date, 'mm/dd/yyyy', 101)

convert(date, 'dd-mm-yyyy', 105)

2 Answers2