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

Reported dates not matching details page timestamps

Moonstone

Reported dates not matching details page timestamps

Please see attached detailed question
5 REPLIES 5

Reported dates not matching details page timestamps

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

Reported dates not matching details page timestamps

A second oops - file not attached.

Reported dates not matching details page timestamps

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

Reported dates not matching details page timestamps

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



















RE: Reported dates not matching details page timestamps

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

Announcements
LiveWorx Call For Papers Happening Now!