Jump to content

Date convertion


gwynne

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...