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/default.asp?url=/library/en-us/dndive/html/data04182002.asp
and specify the formatter there.

 

[Cor]

Hi Bill,

Is this not multipost?

Now I become in doubt, it would be better as he/she had crossposted in my
opinion.
(To both newsgroups in one time).

Cor

 

[Jon Skeet [C# MVP]]

Is this not multipost?
Absolutely.

Now I become in doubt, it would be better as he/she had crossposted in my
opinion.
(To both newsgroups in one time).

Agreed. Well, actually, I'd have preferred to only see it on .adonet in
the first place, but a cross-post would have been better than a multi-
post.