Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Documentation for the policies for handling datetime.

Date vs Timestamp

When designing schemas, decide how to represent the date.

  • Date: store only date data. Should appear the same to everyone regardless of timezone. ex. 1/1/2024.

  • Timestamp/datetime: store an exact timestamp of date and time. ex. 1/1/2024 00:00 UTC.

Front-End

If user has to input date/time manually, use MUI Date and Time Pickers.

Back-End

TBD

Prisma

TBD