CODEWITHSUNDEEP
sqlsql-serverdatetimeformatssrs-2008
Svetlana
Svetlana

Reputation: 51

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?

Upvotes: 1

Views: 527

Answers (1)

Thom A
Thom A

Reputation: 95913

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

dd.MM.yyyy HH:mm:ss

Upvotes: 4

Related Questions