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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2007-01-04 : 14:49:56
|
| Gurusi need the format where i can get the date in 24 hr format.Please helpRegardsNitin Gupta |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-01-04 : 15:07:38
|
| Where are you presenting your data? i.e., A report, a web page, Excel, etc? That is where you can format your dates any way that you want. SQL is not a presentation language.- Jeff |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-04 : 16:39:25
|
| CONVERT(varchar, <YourDateTimeColumnNameHere>, 108)Peter LarssonHelsingborg, Sweden |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
24hr date format