Start_Date and End_date display time different than xml

[dlrich]

In most changes, I am seeing the display time in start and end dates that are different than the times when you view or export XML. In most cases, the XML time is about 5 hours ahead. Start Date = 3:34 PM and XML = 20:34 PM. I am in the EST time zone

[Aaron40]

I think this topic was opened twice but here's my response to the other one:
That's interesting but since the times appear to be exact in minutes, it looks like it might be a timezone thing. Are you in the same timezone as your instance?

[dlrich]

We are self hosting so I am in the same time zone

[CapaJC]

Date/time values are stored in the database in UTC (Coordinated Universal Time), so that's what you'll see when you export to XML. XML gives you the value from the database. This is (one reason, anyway) so that if one user exports to XML, and another user in a different time zone imports the file, the actual value in the database doesn't change.

[dlrich]

So this is intentional? And, if we wanted to make it consitent, could we change the UTC to be on EST for example? Most of our business is in EST. Also add that we are on premise instance and use Oracle DB.