|
<< Click to Display Table of Contents >> Navigation: Telegram > 2023 > 08 > 14 > Telegram_2023-08-14T22 |
2023-08-14T22:43:23
In some countries like Iran and afghanistan we have different date system which is not supported with the usual date utilities.
It cause to use string data types to managing data operations instead of usual date utilities.
infact we have to use other solutions like using string data types or separating date sections (saving day,month and year in different fields in database using string or numeric data types)
for example today is 24/05/1402 in Iran and also afghanistan.
(Other countries like tajikistan and ... that were part of persian empire in past, had use the same date system, but recently they changed their official date system to gregorian date system)
what do you advice for us?
what is the right solution?
2023-08-14T22:51:58
I would consider using UnixDateTime with a few year calculations
2023-08-14T22:53:21
that way you keep date as a double which you can do calculations with (use DateUtils for example) and have a better index in databases