PalisadoesFoundation / talawa

Community Organization Management Software. Click on the link below to see our documentation.
https://docs.talawa.io/
GNU General Public License v3.0
306 stars 434 forks source link

Mobile: Store all dates in the database in UTC #2446

Closed palisadoes closed 2 months ago

palisadoes commented 3 months ago

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

Approach to be followed (optional)

Additional context

Related issues:

  1. https://github.com/PalisadoesFoundation/talawa-admin/issues/1800
  2. https://github.com/PalisadoesFoundation/talawa-api/issues/2096
  3. https://github.com/PalisadoesFoundation/talawa-admin/issues/1813
  4. https://github.com/PalisadoesFoundation/talawa/issues/2446

Potential internship candidates

ArinNigam commented 3 months ago

I would like to work on this issue

ArinNigam commented 2 months ago

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 commented 2 months ago

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

palisadoes commented 2 months ago

Closing. We need to discuss this more here: