Date Conversion

I have this in my SQL 2000 DB
2003-12-17 00:00:00
smalldatetime format
I need to convert this to 12/17/2003, I can do this in another column if
necessary. Can this be done using the UPDATE command?Date/time values are not STORED in any format like what you are seeing.
That is just how the internal values are being presented to you.
It sounds like you want dates returned to you in a specific format for
presentation purposes. Typically, the best place to do this is at the
presentation layer.
In any case, mm/dd/yyyy is a very poor choice unless you have a very limited
audience. While 12/17/2003 might be pretty clear, what about 06/08/2003?
To some people that date is in June, to others it is in August. 2003-06-08
or 2003-08-06 are much more clear and unambiguous.
http://www.karaszi.com/SQLServer/info_datetime.asp
"HeartSA" <HartSA@.yahoo.com> wrote in message
news:eyH3gnuQGHA.3872@.TK2MSFTNGP15.phx.gbl...
>I have this in my SQL 2000 DB
> 2003-12-17 00:00:00
> smalldatetime format
> I need to convert this to 12/17/2003, I can do this in another column if
> necessary. Can this be done using the UPDATE command?
>
>