datetime format

[Esref Durna]

my sql server have this datetime format ( yyyy-mm-dd )
how could i change it to dd.mm.yyyy format

thanks

[William Ryan eMVP]

Esref:

I answered it in the ADO.NET ng (so be nice and avoid the cross posts) but
here's the answer Esref:

Do you want to change the way SQL Server physically stores the data, or do
you just want to change the format in a control once your query is returned?
If the first, you'll need to use SET DateFormat but AFAIK there isn't a
specifier for the '.' period character as opposed to a hyphen.

If it's the second, you can just add a handler for the Bound Control's
format event
http://msdn.microsoft.com/library/de...ta04182002.asp
and specify the formatter there.
"Esref Durna" <99****@students.emu.edu.tr> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

my sql server have this datetime format ( yyyy-mm-dd )
how could i change it to dd.mm.yyyy format

thanks