Date convertion

[gwynne]

hi I was told by your support to raise this, Please can someone tell me what mechanism is used to do the time conversion from the Database end to the service manager front end.

This is so we can accurately report on items.

I understand the db is UTC but our front end is GMT

Cheers

Gareth

[Gerry]

Gareth,

Not sure the question is clear which is probably why no response. Date/times in the database are stored as DATETIME types and everything is in UTC yes, everything comes back in the API's as UTC so you have to do a local timezone conversion for presentation. If you can be a bit more specific about what you are trying to achieve I can probably give you some guidance

Gerry