I have a field with birthday which stores birthday as either '7/08/1986' or '07/08/1986'.this is field already in existing table which i can not change the definition of the field.
I want to convert the value to be looking like this '1986-08-07'.kindly note down it shd not be like '1986/08/07'. fundamentally we have to convert from DD/MM/YYYY to YYYY/MM/DD. the field i am going to store the altered value can be changed to date field or varchar field as per your kind suggestion and not the source column. Kindly note down this is all in SQL Server 2005.
Additionally, if the date is in single digit means still the output shd be shown in double digit like '07' not '7'.
How do I do this conversion?
People already given me some answers which did not solve the issues.
. i thank them heartfully for their response. Your kind replies will help me out. My thanks in advance.