I have a simple question: 

```
select cast( '11-04-15' as date)

```

works in SQL, but

```
select cast( '14-04-15' as date)

```

throws an error

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

```

Why does it happen?  

Dates above 12 throw the error.