0

I have a report in SSRS , where i want to show date time in text box in CET? How to do this?

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
AJ01
  • 235
  • 1
  • 3
  • 16
  • Does CET mean "Central European Time"? Does the original date time field have a timezone setting? Are you getting the original date time field from a SQLServer database? –  Mar 26 '12 at 09:13
  • Yes CET is Central European time. I was using expression in text box as =Now (format- dd-MMM-yyyy hh:mm:ss zzz) this format is giving output in this form 26-Mar-2012 01:02:03 + 05:30. – AJ01 Mar 26 '12 at 09:21

1 Answers1

0

SSRS doesn't support timezones (beyond formatting datetime strings to include the timezone), although the accepted answer on this MSDN thread suggests changing the timezone on your reporting machine as a workaround.

If your report is retrieving its data from a SQLServer database, then the accepted answer to this StackOverflow question may help you to convert between timezones.

If your report is retrieving its data from a different RDBMS, then the database may offer greater inbuilt support for timezone functionality.

Community
  • 1
  • 1