how to change date format in my table

[harithadotnet]

Hi I have craeted one table in sql server 2000. The table have one one date field inserted as mm/dd/yy format.now i want to update all records date as dd/mm/yy format .how to make it.please help me.Its very urgent.

Haritha

[N a v a n e e t h]

harithadotnet wrote:

Its very urgent.

Read this[^]. It's urgent too

harithadotnet wrote:

i want to update all records date as dd/mm/yy format

I guess it's a presentation issue. Let SQL server stores date in it's own format, you convert the format using CONVERT function when selecting. Read this[^] to get an idea.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions