SQL

SSRS Format codes

If you use SQL Server Reporting Services (SSRS), then you have probably used the “Format Code” setting when desiging a report. But what codes are available, and where can you find a list of them? Below is a list of what I have been able to find, it may not be complete, but its a start:

Number

1234 g
1,234.00 N
1234 D0
1234.00 F
1.234123e+003 e

Date

9/21/2009 10:06 AM g
Monday, September 21, 2009 D
9/21/2009 d

Time

9/21/2009 10:06 AM g
10:06:25 AM T
10:06 AM t

Percentage

123,400.00 % P
123,400 % P0

Currency

$1,234.12 C

3 thoughts on “SSRS Format codes

  1. Thanks a lot this page help a lot.
    I would like to add date format which is "d" "mm/dd/yyyy" and MMM-YY like MAR-10,

    Thanks…..javascript:void(0);

Leave a Reply

Your email address will not be published. Required fields are marked *