search

moneymanagerex / mmex-ios

Manage your finances on-the-go, encrypted for security, and sync via your cloud
https://ios.moneymanagerex.org/
8 stars 2 forks source link

Date formats in database #116

Open georgeef opened 1 week ago

georgeef commented 1 week ago

Date fields

table field format
CURRENCYHISTORY_V1 CURRDATE yyyy-MM-dd
ACCOUNTLIST_V1 INITIALDATE yyyy-MM-dd
ACCOUNTLIST_V1 STATEMENTDATE yyyy-MM-dd
ACCOUNTLIST_V1 PAYMENTDUEDATE yyyy-MM-dd
ASSETS_V1 STARTDATE yyyy-MM-dd
STOCK_V1 PURCHASEDATE yyyy-MM-dd
STOCKHISTORY_V1 DATE yyyy-MM-dd
CHECKINGACCOUNT_V1 TRANSDATE yyyy-MM-dd'T'HH:mm:ss
CHECKINGACCOUNT_V1 LASTUPDATEDTIME yyyy-MM-dd'T'HH:mm:ss
CHECKINGACCOUNT_V1 DELETEDTIME yyyy-MM-dd'T'HH:mm:ss
BILLSDEPOSITS_V1 TRANSDATE yyyy-MM-dd'T'HH:mm:ss
BILLSDEPOSITS_V1 NEXTOCCURRENCEDATE yyyy-MM-dd

Date values in INFOTABLE_V1

INFOVALUE format
CREATEDATE yyyy-MM-dd
*_FILTER_LAST_USED yyyy-MM-dd

Note

If a field with format yyyy-MM-dd'T'HH:mm:ss has a value of the form yyyy-MM-dd, it is padded with T00:00:00.

georgeef commented 1 week ago

@guanlisheng Please review the table, then I'll implemented it in Data.

guanlisheng commented 1 week ago

yup, this is the case as the original mmex4desktop uses wxWidget's FormatISOCombined doc

Returns the combined date-time representation in the ISO 8601 format "YYYY-MM-DDTHH:MM:SS".