Posted by robboll on 09/04/07 05:56

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

• Next in forum: Re: Different collations in a database
• Prev in forum: Is ROLLUP really better than doing a nested query when rank is involved?
• Thread view: Format for six character date

[Reply to this message]