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 |
|
my_aro
Yak Posting Veteran
50 Posts |
 Posted - 2005-11-09 : 21:36:07
|
| is there a way that i can ommit the time in my datetime data 2005-05-05 00:00:00.0 having only 2005-05-05 on the display? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-11-09 : 21:53:42
|
| use :convert(char(10), your_datetime, 121)[KH] |
 |
|
|
my_aro
Yak Posting Veteran
50 Posts |
Posted - 2005-11-09 : 22:51:49
|
| thank u! god bless! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-10 : 00:14:16
|
| Where do you want to show the converted dates?If you use Front End aplication, you can make use of Format function thereMadhivananFailing to plan is Planning to fail |
|
|
|
my_aro
Yak Posting Veteran
50 Posts |
Posted - 2005-11-10 : 01:32:22
|
| ive done it inside my jsp page as i have called my sql template.. its ok thanks for the concern.. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-10 : 01:41:41
|
| Then use Format function at JSP pageMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
help please