Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Problem with the diffmin function when I have different time zone
Migrateduser
<p>Hi, </p>
<p> </p>
<p>I'm tring to understand something with the datetime. </p>
<p> </p>
<p>I'm using a date in the database, i received the good date in the data binding. But I need to have the difference between now and the date in my record. </p>
<p> </p>
<p>My data is on one french server (for example) and I'm at Hawaii or Alaska [I changed the time zone]. I didn't receive the same minutes. [hawaii : 30 min more and Alaska : 59 min more]. </p>
<p> </p>
<p>To understand what I did : </p>
<p>I create one date : </p>
<pre class="_prettyXprint">
var dateOne = new Date();</pre>
<p>and the second with my data : </p>
<pre class="_prettyXprint">
var dateTwo = new Date(dataSetRow["column"]);</pre>
<p>and I try to take the difference minutes : </p>
<pre class="_prettyXprint">
var mins = BirtDateTime.diffMinute(dateOne, dateTwo);</pre>
<p> I tried to change the web.xml : </p>
<pre class="_prettyXprint _lang-">
<!--
Default timezone setting.
Examples: "Europe/Paris", "GMT+1".
Defaults to the container's timezone.
-->
<context-param>
<param-name>BIRT_VIEWER_TIMEZONE</param-name>
<param-value></param-value>
</context-param>
</pre>
<p>with the <param-value></param-value> GTM+1 but it didn't work. </p>
<p> </p>
<p>Could you help me to "force" the new date to take the french time zone (or another one)? </p>
<p> </p>
<p>Thanks,</p>
Find more posts tagged with
Comments
There are no comments yet