468,510 Members | 1,736 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,510 developers. It's quick & easy.

datetime format

my sql server have this datetime format ( yyyy-mm-dd )
how could i change it to dd.mm.yyyy format
or what should i do?
thanks

Nov 20 '05 #1
1 1064
I also had a same prob with the dateformat in my application, for this what
I did, I used datetimepicker control, and I get data from SQL Database to
the datetimepicker and then can easily get the format dd/mm/yyyy or
alternate way is to store date in string format in SQL Database and then get
it from the database and if you store date in SQL Database as dd/mm/yyyy
itself then no need to convert but, if its in mm-dd-yyyy then take it in
datetimepicket control and then you can get date in format you want.. it can
be done by the following way...

datetimepickercontrol.values.day & "/" & datetimepickercontrol.values.month
& "/" & datetimepickercontrol.values.year

this gives date in DD/MM/YYYY format.

Hope this helps.

--
Dhaval Faria
Founder, Programmer
Hirdhav (http://www.hirdhav.com)
Microsoft India Community Star
"Esref Durna" <99****@students.emu.edu.tr> wrote in message
news:ep**************@TK2MSFTNGP09.phx.gbl...
my sql server have this datetime format ( yyyy-mm-dd )
how could i change it to dd.mm.yyyy format
or what should i do?
thanks

Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Fritz Switzer | last post: by
38 posts views Thread by nobody | last post: by
26 posts views Thread by Reny J Joseph Thuthikattu | last post: by
11 posts views Thread by Cor Ligthert | last post: by
4 posts views Thread by Arpan | last post: by
5 posts views Thread by js | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.