Change Default Datetime format in Table Output

[amzar]

Hi All,

May I know how I can change the default format for Show the time in the Admin - Localization? I want to make all the DateTime show the seconds.

Now, I need to change the format of every column manually.

[AndrewMBaines]

It's not available globally (oddly). Best place would be to change in the Data Model for each field.

[amzar]

hi Andrew, sorry for the late reply.

I already changed Format in data models, but when I query it (SQL query)... the output still not change to desired format.

[AndrewMBaines]

SQL Query doesn't refer to the data model.
I rarely use SQL query in Metabase. I find it better for reuse to just create a view in the database. That can then have it's formatting defaulted in Metabase.

[amzar]

got it. thank you!