Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2010-03-03 : 02:04:52
|
| iam using sql 2005 ,in my date field the value storing like10/02/2010 00:00:00but i want to show only 10/02/2010 in front end screenif any dateformat function ?looking forward ur replyRegardsKannan.dDesikankannan |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-03-03 : 02:08:24
|
| Well u can do it in frontend.If using .Net use YourDatefield.ToString("dd/MM/yyyy")PBUH |
 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
|
|
|
|
|
dateformat in sql2005