Change the date format of modified date which is presisted

[ea0921]

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

[Geert Bellekens]

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

Geert

[Eve]

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.