Using SQL Server 2000 in a view, if the data is Char and six
characters like: 081564

How do I convert it to a date that looks like: 08/15/1964 and is a
date.

I am trying:

CONVERT (varchar, SUBSTRING(Col005, 1, 2) + '/' + SUBSTRING(Col005, 3,
2) + '/' + SUBSTRING(Col005, 5, 2), 112)

but it returns 08/15/64. Anyone tell me what I'm doing wrong.

Thanks in advance!

RBolling

This should work

select
CONVERT (varchar, cast(SUBSTRING('081564' , 1, 2) +
'/' + SUBSTRING('081564' , 3,
2) + '/' + SUBSTRING('081564' , 5, 2) as datetime), 101)

-
Shiju


On Sep 4, 10:56 am, robboll <robb... (AT) hotmail (DOT) com> wrote: