What's an efficient way to convert month and year string to a date?

Posted by adam0101 on Stack Overflow See other posts from Stack Overflow or by adam0101
Published on 2010-03-24T22:15:26Z Indexed on 2010/03/24 22:43 UTC
Read the original article Hit count: 235

Filed under:
|
|
|

I have column with varchar values like "022008" that I need to convert into a datetime like "02/01/2008". This will run on millions of records for a conversion process. What is an efficient select statement for doing this?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server