Reported dates not matching details page timestamps

[MikeLockwood]

Please see attached detailed question

[MikeLockwood]

Oops - I attached a file with errors - please see updated.

[MikeLockwood]

A second oops - file not attached.

[jessh]

You didn't attach an updated file. [Thunderbird 3 would have reminded you.]

I will note that dates are stored in the database in GMT. I believe
reporting may well leave times in GMT, whereas the UI uses the server
time zone and/or user preference specified time zones to display.

On 3/11/2010 3:51 PM, Lockwood,Mike,IRVINE,R&D wrote:
> Oops - I attached a file with errors - please see updated.
>

[ddemay]

Hmmm. This is an outloud written thought.



Wondering if you set the timezone offset in the select? Never tried. If you
pull back a list of object using SQL, and view the timestamp, how does one
format it that way?





<xslaram name="dateformat">yyyy-MM-dd'T'HH:mm:ssZ</xslaram>

<xsl:variable name="tz" select="java:java.util.SimpleTimeZone.new(0,&lt;br /&gt;&lt;br /&gt;"GMT+00:00")"/>

<xsl:variable name="formatter"&lt;br"/>
select="java:java.text.SimpleDateFormat.new($datef ormat)"/>

<xsl:variable name="settz" select="...

[patrick.chin1]

Just like in thebrowser, you must accomodate the timezones. If you look at the database, the values are in Greenwich time.