> I need to convert the dates in a table from yyyy-mm-dd to mm/dd/yyyy.  How
> can this be done?  All I have been able to find is how to convert datetime
> fields and I haven't been able to get that to work for what I need.

> Thanks.

> Are you saying you want to change the underlying data in the table? If so,
> then I assume you are storing your dates in a CHAR type column and are not
> using a datetime or smalldatetime column.

> To change the dates for a character column, do something like this:

> Update table
> Set column = substring(column, 6, 2) + '/' + substring(column, 9, 2) + '/'
+
> substring(column, 1, 4)

> If you are dealing with a datetime / smalldatetime column you can either
> format the column value on the client side, or use the CONVERT function:

> --
> David Gugick
> Intrinsic Design, Inc.
> Coefficient - Database Analysis for Microsoft SQL Server
> http://www.idisoft.com

> > I need to convert the dates in a table from yyyy-mm-dd to mm/dd/yyyy.
How
> > can this be done?  All I have been able to find is how to convert
datetime
> > fields and I haven't been able to get that to work for what I need.

> > Thanks.