SSRS TimeOfDay Function

The SSRS TimeOfDay function is a Date and Time function that returns the current local time of the day according to your system. The syntax of the TimeOfDay function to print the current time is as shown below.


To demonstrate the SSRS TimeOfDay function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.

Source Table

SSRS TimeOfDay function Example

For this, let me add a new column to the right side of the Hire Date column and name it TimeOfDay. Next, right-click the textbox under TimeOfDay and choose Expression. To understand the report, I suggest you refer to the articles on charts, tables, grouping, and format tables in SSRS.

Choose the Expression option

It opens the following expression window to print the present time. The below SSRS TimeOfDay function prints the current local time of the day as per the system.

SSRS TimeOfDay Function expression to returns time of the day

Please click the preview tab to see the report. If you notice the reports, they show the current system local time and the date set to 1/1/00001.

SSRS TimeOfDay Function to returns current local time of the day preview

To return the time (only), please change the text box properties from default to Time. For this, right-click on the text box and choose the Text Box properties -> Number -> Time -> Choose the Type (01:30:00 PM). For more functions >> Click Here!

SSRS TimeOfDay Function to returns current system time of the day