http://www.sqlservercentral.com/blogs/whatilearntatwork/2012/05/21/ssrs-format-option-for-milliseconds/

Printed 2014/09/14 10:23PM

SSRS: FORMAT option for milliseconds

2012/05/21

Some of our reports have hyperlink enabled on few metrics which points to an internal website. Recently there was a change in the internal website which required us to send the a particular Date as a parameter. The page was expecting the milliseconds also.

This looked simple as we thought of using FORMAT function, but we could not find the option to include milliseconds in FORMAT function. We spent a couple of hours going thru different blogs but most of them stopped with seconds.

Finally in one of the forum, in an unrelated post, we came across the format for milliseconds. ¬†And it is nothing but “f” :)

=format(now(),”MMM/dd/yyyy hh:mm:ss:fff”)

returns



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.