[progress Communities] [progress Openedge Abl] Forum Post: Re: Language / Date & Time-format

[Ricardo Rafols]

DefaultLangCode and DefaultDateFormat are only used for new records when no language selection is made or available. It does not apply for existing users/tenants unless their language is not set. The possible values for DefaultDateFormat are: Value Format 0 MM/dd/yyyy hh:mm a 1 dd/MM/yyyy HH:mm 2 dd.MM.yyyy HH:mm 3 MM/dd/yyyy HH:mm 4 yyyy-MM-dd HH:mm 5 dd-MM-yyyy HH:mm 6 yyyy/MM/dd HH:mm 7 yyyy-MMM-dd HH:mm 8 MM/dd/yyyy HH:mm:ss One thing is the way date and time are displayed, another is how the database stores these values. Internally, the database stores it as YYY-MM-DD hh:mm:ss Timezone (timestamp field).

Continue reading...