cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Reported dates not matching details page timestamps

MikeLockwood
22-Sapphire I

Reported dates not matching details page timestamps

Please see attached detailed question
5 REPLIES 5

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

A second oops - file not attached.

jessh
5-Regular Member
(To:MikeLockwood)

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.
>

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="...














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

Top Tags