Table get_utc_dates in xml report

snt · #1 (**permalink**) 08-11-2009, 06:29 PM

Hi,

If I pull the xml report for a date mm/dd/yyyy, I see the following as the request parameters:
<param name="FROM">mm/dd/yyyy 21:00:00</param>
<param name="TILL">mm/dd/yyyy 20:59:59</param>

and see the following in the table get_utc_dates:
<column name="CLIENTFROM">mm/dd/yyyy 17:00:00</column>
<column name="CLIENTTILL">mm/dd/yyyy 16:59:59</column>

Doubts:

1. It appears that the date/time shown in table get_utc_dates is in NY local time and not in UTC format as the name "get_utc_dates" suggests, is that correct?

2. If the answer to question 1 is yes, then what about the time it shows in the request param FROM and TILL, what time zone are those from?

Thanks

fxsv · #2 (**permalink**) 08-18-2009, 09:08 AM

It seems that these dates is mixed. First dates FROM/TILL in UTC timezone, while second ones CLIENTFROM/CLIENTTILL in NY local time.

snt · #3 (**permalink**) 08-18-2009, 02:02 PM

Thanks fxsv, that looks correct, so once the DST ends, I guess the parameters will change to:
<param name="FROM">mm/dd/yyyy 22:00:00</param>
<param name="TILL">mm/dd/yyyy 21:59:59</param>