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 |
|
ich28
Starting Member
5 Posts |
 Posted - 2008-06-17 : 04:52:50
|
| The format of execution time is as below: 6/17/2008 4:43:07PM. Is it possible to change the format of execution time into the following format: 17/06/2008 16:43:07 ????Thanks.... |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-17 : 05:35:50
|
| Look up CONVERT() in Books Online. |
 |
|
|
chrpeter
Starting Member
31 Posts |
Posted - 2008-06-18 : 12:57:37
|
| Right Click the textbox with the Globals!Execution time in it and click properties.Click the format tab, and enter "dd/MM/yyyy HH:mm:ss" in the format code box(without the " ")I think HH is the correct format for military time... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-18 : 13:05:41
|
| or use FormatDateTime() function available in SSRS |
|
|
|
ich28
Starting Member
5 Posts |
Posted - 2008-06-18 : 21:19:07
|
Thanks for the replied |
|
|
|
|
|
|
Change Format of Global!Execution Time