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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-11-20 : 06:52:10
|
| hi all,i've inserted one row like thisinsert into e1 select 'phani',18000,'15-oct-2007'i got the out put like thisphani 18000 2007-10-15 00:00:00.000how can i get the same output as i've given?thankyou very muchVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-11-20 : 07:30:20
|
| where are you viewing this "output"? On a web site? format it there. In a report? Format it there. In query analyzer? who cares what it looks like in query analyzer! FORMATTING IS DONE IN THE FRONT END![Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-20 : 07:36:07
|
Do it in front end  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
different output