SSRS: FORMAT option for milliseconds

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

About these ads

About Suresh Kumar D

Hardcore SQL Developer and aspiring Database Architect.
This entry was posted in SSRS. Bookmark the permalink.

4 Responses to SSRS: FORMAT option for milliseconds

  1. Pingback: Link Resource # 55 : May 18 – May 24 « Dactylonomy of Web Resource

  2. Dave says:

    Thank you. It’s crazy how hard it is to find that out! Presumably ‘f’ stands for fraction of a second. Hardly intuitive, though.

  3. I think everything said made a ton of sense.
    However, think about this, what if you wrote a catchier post title?

    I ain’t saying your content isn’t solid, but what if you
    added a title that makes people want more? I mean SSRS: FORMAT option for milliseconds | Kirukkal a.
    k.a Scribbling is a little plain. You should look at Yahoo’s home page and see how they create post headlines to get people to open the links. You might add a video or a pic or two to get readers excited about what you’ve got to say.
    In my opinion, it might bring your website a little livelier.

  4. What’s up, all is going well here and ofcourse every one is sharing information, that’s
    in fact good, keep up writing.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s