Mobile: Store all dates in the database in UTC

[palisadoes]

Is your feature request related to a problem? Please describe.

The Talawa applications assume that the:

1. user and organization are in the same timezone
2. API server and the organization are in the same timezone

This will create confusion when an organization’s stakeholders and its service providers are geographically dispersed.

For example someone someone in the US state of New Mexico creating and event in neighboring Texas will have concerns. There are some cities in the USA like Minneapolis and Kansas City that straddle timezones.

Describe the solution you'd like

The client must:

1. Only update the database with date values in UTC. This means you will have to use the local timezone of the client as the basis for converting database times to UTC.
2. Convert dates read from the database to the local timezone of the client for presentation to the end user

There must be a date data conversion function that is used to make this consistent.

Describe alternatives you've considered

• N/A

Approach to be followed (optional)

• N/A

Additional context

Related issues:

1. Admin - Set Organization Timezone Feature talawa-admin#1800
2. API - Set Organization Timezone Feature talawa-api#2096
3. Admin: Store all dates in the database in UTC talawa-admin#1813
4. Mobile: Store all dates in the database in UTC #2446

Potential internship candidates

• Please read this if you are planning to apply for a Palisadoes Foundation internship Student Internship Programs #359

[ArinNigam]

I would like to work on this issue

[ArinNigam]

I have my various evaluatives planned for the next week in my college. So won't be able to work on the following issue till the next week. I am unassigning myself if anyone else want to take up this issue they can go ahead.

[Azad99-9]

I would like to work on this please assign me @Cioppolo14

[palisadoes]

Closing. We need to discuss this more here:

• Standardize DB chronological fields to DateTime + make the Talawa clients store DateTime in UTC talawa-api#2222