Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: ea0921 on November 14, 2023, 02:55:49 pm

Title: Change the date format of modified date which is presisted
Post by: ea0921 on November 14, 2023, 02:55:49 pm

Hello,

Currently, the modified date is presisted in "yyyy-mm-dd" format in the database. I want to change the date format to "yyyy/mm/dd" format. My short hand date format is in "mm/dd/yyyy" format.

How can I change the format that is stored for modified date ?

Thanks

Title: Re: Change the date format of modified date which is presisted
Post by: Geert Bellekens on November 14, 2023, 03:55:27 pm

The date is persisted as a date, not as a formatted string.

Geert

Title: Re: Change the date format of modified date which is presisted
Post by: Eve on November 14, 2023, 04:27:55 pm

I'm guessing you're referring to a SQLite file database, because SQLite is the only supported repository type that doesn't support a datetime data type.

If that's the case, the answer is that it's not intended to be saved the the local format. It needs to be readable if the file is transferred between systems, including if they have a different locale.