The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Question

0.00/5 (No votes)

See more:

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
I tried to convert in below format:

convert(datetime, '27/01/1710', 103).

Posted 15-Mar-15 21:04pm

anil420

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Saral S Stalin · Accepted Answer · 2015-03-15T21:08:00

Solution 1

Datetime does not support years below 1750 AD. Try converting to date

SQL

SELECT convert(date, '27/01/1710', 103)

Posted 15-Mar-15 21:08pm

Saral S Stalin

v2

Comments

aarif moh shaikh 17-Mar-15 1:50am

good one...

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

1 solution

Solution 1

Add your solution here

Preview 0

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us