nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

TimeZone Problem

Jacky88

We are using BIRT for reporting in our application. When we tested the reports on local end, it was working as expected. Then we deployed the application on test server where OS is ubuntu and we are using mysql as our database server. Now the timezone of both OS and mysql are set to IST. But when we generate the report, it shows date/time before 5:30 hours i.e. GMT time. Any suggestions please?

Find more posts tagged with

Comments

mcremer

<blockquote class='ipsBlockquote' data-author="'Jacky88'" data-cid="83885" data-time="1318239314" data-date="10 October 2011 - 02:35 AM">
We are using BIRT for reporting in our application. When we tested the reports on local end, it was working as expected. Then we deployed the application on test server where OS is ubuntu and we are using mysql as our database server. Now the timezone of both OS and mysql are set to IST. But when we generate the report, it shows date/time before 5:30 hours i.e. GMT time. Any suggestions please? </blockquote>
 
Well its a java thing. 
 
Java takes the local of your OS. So if you want to run it make sure the macine your running the java on is set to the same local (trough boot options or setting the OS to it). 
 
If you do not want to do that. You can use some start up parameters or script it in your report.

Jacky88

<blockquote class='ipsBlockquote' data-author="'mcremer'" data-cid="83899" data-time="1318250856" data-date="10 October 2011 - 05:47 AM">
Well its a java thing. 
 
Java takes the local of your OS. So if you want to run it make sure the macine your running the java on is set to the same local (trough boot options or setting the OS to it). 
 
If you do not want to do that. You can use some start up parameters or script it in your report. </blockquote>
 
Thanx, Mcremer, for the reply.But my OS, mysql and jboss all r set to use IST .Still the problem exist. 
Also, i have tried setting the BIRT_viewer_timezone in the web.xml to "IST" but even that was of no use. 
 
Can u help me out. 
 
Thanx in advance.

mcremer

<blockquote class='ipsBlockquote' data-author="'Jacky88'" data-cid="83925" data-time="1318312443" data-date="10 October 2011 - 10:54 PM">
Thanx, Mcremer, for the reply.But my OS, mysql and jboss all r set to use IST .Still the problem exist. 
Also, i have tried setting the BIRT_viewer_timezone in the web.xml to "IST" but even that was of no use. 
 
Can u help me out. 
 
Thanx in advance. </blockquote>
 
 
Try somting like: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
nl_NL = new Packages.java.util.Locale("nl","NL");
dfd = new Packages.java.text.SimpleDateFormat("dd-MM-yyyy",nl_NL);
dfd.format(BirtDateTime.today());
</pre>