Convert free text date to 'MMDDYYYY' format

General

Convert free text date to 'MMDDYYYY' format

Hi,

I'd like to convert a free text date to 'mmddyyyy' format.

The free text date are in different format: 10/12/11, 8/25/2010, 1/3/13.

Thank you,

Tags (1)
1 REPLY
Enthusiast

Re: Convert free text date to 'MMDDYYYY' format

You can't do that in one simple SQL. You have to cast the text and there is only one format that you can define while casting. 

You probably need to write some routine (SP or UDF) to get that or may be find one that has already been developed.