datetime format

  • Thread starter Thread starter Esref Durna
  • Start date Start date
E

Esref Durna

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

thanks
 
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.
 
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
 
Cor said:
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).
Click to expand...

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.
 
Back
Top