Home
> Reporting Services > Date Formatting in Reporting Services – list of format codes
Date Formatting in Reporting Services – list of format codes
The Date Formatting article that I wrote earlier seems to be quite popular. As a follow up to that , I stumbled accross the full list of date formatting patterns on MSDN. I haven’t had a chance to try out them all , but here it is :
Format Pattern | Description |
---|---|
d | The day of the month. Single-digit days will not have a leading zero. |
dd | The day of the month. Single-digit days will have a leading zero. |
ddd | The abbreviated name of the day of the week, as defined in AbbreviatedDayNames |
dddd | The full name of the day of the week, as defined in DayNamesTD> |
M | The numeric month. Single-digit months will not have a leading zero. |
MM | The numeric month. Single-digit months will have a leading zero. |
MMM | The abbreviated name of the month, as defined in AbbreviatedMonthNames. |
MMMM | The full name of the month, as defined in MonthNames. |
y | The year without the century. If the year without the century is less than 10, the year is displayed with no leading zero. |
yy | The year without the century. If the year without the century is less than 10, the year is displayed with a leading zero. |
yyyy | The year in four digits, including the century. |
gg | The period or era. This pattern is ignored if the date to be formatted does not have an associated period or era string. |
h | The hour in a 12-hour clock. Single-digit hours will not have a leading zero. |
hh | The hour in a 12-hour clock. Single-digit hours will have a leading zero. |
H | The hour in a 24-hour clock. Single-digit hours will not have a leading zero. |
HH | The hour in a 24-hour clock. Single-digit hours will have a leading zero. |
m | The minute. Single-digit minutes will not have a leading zero. |
mm | The minute. Single-digit minutes will have a leading zero. |
s | The second. Single-digit seconds will not have a leading zero. |
ss | The second. Single-digit seconds will have a leading zero. |
f | The fraction of a second in single-digit precision. The remaining digits are truncated. |
ff | The fraction of a second in double-digit precision. The remaining digits are truncated. |
fff | The fraction of a second in three-digit precision. The remaining digits are truncated. |
ffff | The fraction of a second in four-digit precision. The remaining digits are truncated. |
fffff | The fraction of a second in five-digit precision. The remaining digits are truncated. |
ffffff | The fraction of a second in six-digit precision. The remaining digits are truncated. |
fffffff | The fraction of a second in seven-digit precision. The remaining digits are truncated. |
t | The first character in the AM/PM designator defined in AMDesignator or PMDesignator, if any. |
tt | The AM/PM designator defined in AMDesignator or PMDesignator, if any. |
z | The time zone offset ("+" or "-" followed by the hour only). Single-digit hours will not have a leading zero. For example, Pacific Standard Time is "-8". |
zz | The time zone offset ("+" or "-" followed by the hour only). Single-digit hours will have a leading zero. For example, Pacific Standard Time is "-08". |
zzz | The full time zone offset ("+" or "-" followed by the hour and minutes). Single-digit hours and minutes will have leading zeros. For example, Pacific Standard Time is "-08:00". |
: | The default time separator defined in TimeSeparator. |
/ | The default date separator defined in DateSeparator. |
% c | Where c is a format pattern if used alone. The "%" character can be omitted if the format pattern is combined with literal characters or other format patterns. |
\ c | Where c is any character. Displays the character literally. To display the backslash character, use "\\". |
Categories: Reporting Services
this is so handy! thanks for the post.
LikeLike
How do we set the above date time formats on the report server? Currently we have a String report parameter which accepts date time values. If the values are passed in m/d/yyyy hh:mm:ss AM/PM then only they are accepted otherwise ReportParameterValueNotSetException is thrown with the following message : This report requires a default or user-defined value for the report parameter \’param1\’. To run or subscribe to this report, you must provide a parameter value.I am using SQL Server SP3 (9.0.4035)
LikeLike
The link which you shared is about changing the display of the date time fields. The problem solution I am looking for is about passing parameter values to a string queried report parameter accepting date time values. I guess there should be a configuration setting on the report server which specifies the date time format in which the report parameter values are accepted which currently is set to "m/d/yyyy hh:mm:ss AM/PM".
LikeLike
Re: No Name – that is strange , what is the type of the parameter ? If it is a string I don\’t think that that will generate the error you are seeing
LikeLike
Big help – Thanks.
LikeLike
Brilliant article. I didn’t know it was as simple as this or that you could combine the letters to get the results you want! Thanks.
LikeLike
This is fantastic! I have been looking for something like this for years. I will definitely be saving this post.
LikeLike
Where is your previous article please?
LikeLike
LikeLike
Hi there! I could have sworn I’ve been to this site before but after browsing through a few of the articles I realized it’s new to
me. Anyhow, I’m definitely delighted I found it and I’ll
be bookmarking it and checking back regularly!
LikeLike
Hi there! This is my first visit to your blog!
We are a team of volunteers and starting
a new initiative in a community in the same niche.
Your blog provided us useful information to work on.
You have done a marvellous job!
LikeLike