CooLDBA (2/11/2010)

---

CREATE TABLE [dbo].[_CalendarDate](
[F1] [varchar](20) NULL
) ON [PRIMARY]

select * from dbo._CalendarDate

8242004
8252004
8262004

select CONVERT(datetime, F1, 103) from _CalendarDate

Syntax error converting datetime from character string.

I want to convert it to datetime, any idea?

CooLDBA (2/11/2010)

---

I was able to change the data to
08-24-2004
08-25-2004
08-26-2004

select CONVERT(datetime, F3, 103) from _CalendarDate

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

(1 row(s) affected)

any clue?