Search code examples
sqlsql-serverdatetimeformatssrs-2008

SSRS DateTime UTC format

Stored Procedure return datetime in utc like: enter image description here

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

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?

Solution

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

    dd.MM.yyyy HH:mm:ss