Change Date formats in Query results

[KevinWellsMLC]

In the query results , currently date fields are showing in 12-14-2020 10:03:42 format. I’d like them to display in 14-DEC-2020 10:21:07 AM format. I’ve attempted to change the format in the format/view –> data format –> both global and datasource settings but have had no success.

Is it possible to change?

System information:
Windows 2012 R2
DBeaver 7.2.4

Connection specification:
Database Oracle 11g

Thanks you.

[kseniiaguzeeva]

Most probably you change the format via settings button in the bottom toolbar. It doesn't work for now #10601

Please right-click the connection name in DB Navigator>select Edit connection>set you date/time format>Press Test connection and press Ok after it.

The changes will be applied.

Please feel free to ask to reopen the ticket if the issue is not resolved.

[KevinWellsMLC]

I followed your instructions. The date format is still not showing correctly in my query results.

[kseniiaguzeeva]

1. Please check also that this option is disabled.
2. How do you write timestamp pattern? Here is my settings

[KevinWellsMLC]

This fixed my issues. Thank you.

[kseniiaguzeeva]

Great!