July 3, 2012 at 9:14 am
Hi,
I have a table with fields containing time stored as float.
Most important part is that I need the milliseconds.....
How do I display this. (Hours are displayed like format(field,"hh:mm:ss"))
What do I need to add after "ss" to have the milliseconds ?
Many tks for your help.
July 3, 2012 at 10:06 am
This should get you started.
http://thavash.wordpress.com/2007/10/02/date-formatting-in-reporting-services-list-of-format-codes/[/url]
I have a table with fields containing time stored as float.
You would probably be better off if you can change this to an appropriate datatype, although sometimes we are stuck with what we have to work with. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 3, 2012 at 11:33 am
Yes this is perfect. Many tks. I had the syntax up to the second only!
For the float format, as I have to compute on them I still believe this is the only solution. In addition, I have to deal with time > 24h... Users want to have time (interruption time for ex as 205:30:20 for 205 hours 30 minutes 20 seconds. and this is already another issue for me as time format is only working as hh:mm:ss ....
July 3, 2012 at 12:07 pm
You are quite welcome. Glad that could help.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply