pshotts,

I don't know for the utc date.

We have a third party helpdesk application which stores the dates as UTC dates.

Now I have to query the past data and I just simply do not know when a specific ticket was open. my query works fine for the actual data but before and after the daylight saving change it cause an error.

As an example: I'm checking how meny tickets are opened per hour and per day and also when my customers starts calling my helpdesk.

Right now I do not know if in march really they started to work at 8 or (as usual) at seven., because my report shows me 7 o'clock.

So UTC or not UTC.....

Bye

Gabor