[wp-meta] [Making WordPress.org] #7071: Events aren't sorted by its time on the online events list page

[Making WordPress.org]

#7071: Events aren't sorted by its time on the online events list page
--------------------------------+-------------------------------------
 Reporter:  renyot              |      Owner:  (none)
     Type:  defect (bug)        |     Status:  assigned
 Priority:  normal              |  Milestone:
Component:  WordPress.org Site  |   Keywords:  has-patch needs-testing
--------------------------------+-------------------------------------
 We currently have an issue with the way we sort
 [https://make.wordpress.org/community/events/online/ the list of online
 events]. The events are originally sorted by their local times stored in
 the database, which leads to incorrect order when viewed globally. For
 instance, an event happening at 4 PM in New York (20:00 UTC) should be
 listed after an event at 5 PM in London (17:00 UTC), but the current
 sorting places the London event after the New York one due to the original
 local time sort.

 In order to rectify this, we need to sort events based on the UTC time
 rather than the local time. By converting each event's local time to UTC
 and then reordering the list, we can ensure a globally accurate
 chronological listing of events.

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/7071>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org