Thursday, April 10, 2014

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


Convert(char(10), MAX(case when A.[NGT_KYC_QUES_PROPERTY]='ResolvedDate'
then cast(left(NGT_KYC_QUES_ANSWER,8) as datetime) ELSE null END), 101)
AS ResolvedDate


No comments:

Post a Comment