Home | Feedback | Login

SQL String to Date

Mostly it is useful in SSIS package data transformation. 

LEN([Extract Date]) > 7 ? 
SUBSTRING([Extract Date],1,2) + "/" + 
SUBSTRING([Extract Date],3,2) + "/" + 
SUBSTRING([Extract Date],5,4) : ""