-
Notifications
You must be signed in to change notification settings - Fork 2
Date formats in database
George Ef edited this page Nov 6, 2024
·
1 revision
| 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 |
| INFOVALUE | format |
|---|---|
| CREATEDATE | yyyy-MM-dd |
| *_FILTER_LAST_USED | yyyy-MM-dd |
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.