Using the following to get events from the Team Calendar DB:
"SELECT ID, ALL_DAY, ORGANISER, DESCRIPTION, START, END, SUMMARY
FROM ao_950dc3_tc_events
WHERE ao_950dc3_tc_events.SUB_CALENDAR_ID in
(SELECT distinct(ao_950dc3_tc_events.SUB_CALENDAR_ID)
FROM ao_950dc3_tc_events, ao_950dc3_tc_subcals
WHERE ao_950dc3_tc_events.SUB_CALENDAR_ID = ao_950dc3_tc_subcals.ID AND
ao_950dc3_tc_subcals.PARENT_ID = 'd73e1dec-0d48-45c0-8205-3e56b72ae914'
) AND
START > '1451703600000'
ORDER BY START"
When I convert the START and END milliseconds to dates, the START is often one day too early. For example, if I add a full day event for 5/16/2018, the START milliseconds converts to 5/15/2018. If it's a 2-day event, the dates seem to work correctly.
Does anyone know if there's a gotcha I don't know about? It's impossibly hard to find details about this DB...