date question

Hi,

I have a string in the format ('MM/DD/YYYY) examples('12/12/2006') or ('2/12/2006') or ('12/1/2006') or ('1/1/2006') .
Have to to take the date and lpad it with ZERO if its a single digit.

Can you please let me know the sql ?

thanks. Received on Sun Jul 02 2006 - 21:52:23 CDT