Hi All,
We have a requirement where we need to convert GMT time zone to the local time zone where ever user running the report.
Data stored in DB is in GMT format. This need to be converted while report is executing.
Ex: 2001-01-01 10:05:00:000 GMT
2001-01-01 5:00:00:000 EST/EDT ( If user is executing the report from US)
2001-01-01 03:35:00:00 IST ( If user is executing the report from India)