SSRS DateTime UTC format

Question

Stored Procedure return datetime in utc like:

In SSRS report I formated date with mask "dd.MM.yyyy hh:mm:ss". But time was change

I think this happens becouse ssrs convert date from dd/MM/yyyy hh:mm:ss PM(AM) format. How can I return time from sp normaly?

DateTime has no format, it's a binary value. SSRS uses the NumberFormat and Culture properties to format dates into strings. Instead of hard-coding the format you could set the Culture of the report/page/table/field to the one you want — Panagiotis Kanavos
What you see in SSMS isn't some built-in format. It's the way SSMS displays dates as text. It uses YYYY-MM-DD HH:mm:ss.fff because it's unambiguous — Panagiotis Kanavos

Larnu Larnu · Accepted Answer · 2019-03-05T13:52:06

Use HH for 24 hour format. hh is 12 hour format. So, your new format would be:

dd.MM.yyyy HH:mm:ss