471,122 Members | 1,125 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,122 software developers and data experts.

datetime format

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

thanks

Jul 21 '05 #1
1 1398
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

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.