Hi,

I was wondering if you could give me some advice regarding the following:

Let's say you have a table with a varchar() column that contains date values in different format.

What if you wanted to convert them all in one format eg: DD/MM/YYYY

Here's some code to help you test.

Create table dbo.date

(

DATE VARCHAR(50)

)

Insert into dbo.date

VALUES ((DATEADD(yy,-45,GETDATE())))

Insert into dbo.date

VALUES ((DATEADD(yy,-35,GETDATE())))

Insert into dbo.date

VALUES ('Jan 1 2005')

Insert into dbo.date

VALUES ('11/23/98')

Insert into dbo.date

VALUES ('11/23/1998')

Insert into dbo.date

VALUES ('72.01.01')

Insert into dbo.date

VALUES ('1972.01.01')

Insert into dbo.date

VALUES ('19/02/72')

Insert into dbo.date

VALUES ('19/02/1972')

Insert into dbo.date

VALUES ('25.12.05')

Insert into dbo.date

VALUES ('25.12.2005')

Insert into dbo.date

VALUES ('24-01-98')

Insert into dbo.date

VALUES ('24-01-1998')

Insert into dbo.date

VALUES ('04 Jul 06')

Insert into dbo.date

VALUES ('04 Jul 2006')

Insert into dbo.date

VALUES ('Jan 24, 98')

Insert into dbo.date

VALUES ('Jan 24, 1998')

Insert into dbo.date

VALUES ('Apr 28 2006')

Insert into dbo.date

VALUES ('01-17-06')

Insert into dbo.date

VALUES ('98/11/23')

Insert into dbo.date

VALUES ('1998/11/23')

Insert into dbo.date

VALUES ('980124')

Insert into dbo.date

VALUES ('19980124')

Insert into dbo.date

VALUES ('28 Apr 2006')

Insert into dbo.date

VALUES ('1972-01-21')

Insert into dbo.date

VALUES ('1972-02-19')

Your help is really appreciated.

Manos