klequis / private-money-client

5 stars 2 forks source link

Should all dates in db be type Date or String #71

Open klequis opened 3 years ago

klequis commented 3 years ago

Currently, dates are stored in db as strings. Should they be dates?

One reason to make them dates in db is when filtering by year and/or month, the string for each transaction (currently >2,700) needs to be converted into a date. See: private-money-client: src/features/selectors/txTblSelectors/txTblSelectors.js.

Impact on code (changes)

Not evaluated yet but possibly considerable.