Thursday, April 10, 2014

changing date format from yyyy/mm/dd to mm/dd/yyyy

thank you so much for the response, I am not sure how to combine it with the statment I am using?


MAX(case when A.[NGT_KYC_QUES_PROPERTY]='ResolvedDate' then CAST(SUBSTRING([NGT_KYC_QUES_ANSWER],5,2) + '-' + SUBSTRING([NGT_KYC_QUES_ANSWER],7,2) + '-' + SUBSTRING([NGT_KYC_QUES_ANSWER],1,4) AS DATE) ELSE '' END)AS ResolvedDate,


No comments:

Post a Comment