I have an sql 2005 database with several fields that need to be timezone agnostic. Using nHibernate interceptors we have fixed the application side and everything is happy. The problem is with our reports.
We are using SQL Reporting Services 2005, the reports reside on a server that lives in MST. The users (most, but not all of them) reside in CST. The times are stored in the DB in UTC.
So I am aware of using the following code:
System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!ShipDate.Value) but this will only convert to server time.
The basic question: Is there a way to convert dates in the report either from UTC to the client's time or from MST to the client's time? Ideally the solution would be something akin to the nHibernate Interceptors so I could convert the report dates from UTC on the client.
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.