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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-07 : 08:05:50
|
| juan manuel writes "Hi, I need to display the datetime info in the following format: "06/04/2005 1:19:32", but instead when I use this:"select date=getdate()", command it displays like this: "2005-04-06 09:31:44.170", how can I change the format so it displays in the way I needThanks" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-04-07 : 08:34:48
|
| select convert(varchar(20),getdate(),103)+' '+convert(varchar(20),getdate(),108)MadhivananFailing to plan is Planning to fail |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-04-07 : 09:02:15
|
| Return the date value to your presentation layer and format it there. SQL should not be used for formatting/presenting data, that is not the purpose of the language. When SQPL is invented (Structured Query and Presentation Language) then you can go crazy with all the formatting you'd like!- Jeff |
|
|
|
|
|
|
datetime formats