Monday SSRS Quick Tip – Formatting 24 hour time

You can format a datetime column as 24 hour time in a Tablix by issuing a capital HH for the hour component in the Format property. e.g. the following expression will show 24 hour time.  Note HH will do leading zeros where applicable, H will not.


dd/MMM/yyyy HH:mm:ss

… and the following expression will show regular 12 hour time with AM/PM.


dd/MMM/yyyy hh:mm:ss tt

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

1 Response

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