I need to Convert date format from 'dd-mmm-yyy ' to 'mm/dd/yyyy'.
and i am using th efollowing function to achieve the same.But just the date value (dd) is getting truncated to month start date.
StringToDate(DateToString(StringToDate(Trim(LNK_Read_Input.IND_DT), "dd-%mmm-%yy"), "%mm/%dd/%2000yy"),"%mm/%dd/%2000yy")
Code: Select all
Eg:
Varchar Current O/p Expected
20-DEC-15 ------- 12/1/2015 --------12/20/2015
20-MAR-14 ------- 3/1/2014 --------3/20/2014
Thanks,
prasad.