Its a native ORACLE date formatting which shows like this: 08-JAN-99 04:05:06 set in the datestyle config param.
Currently running on EDB Advanced Server 12 which allows it as a datestyle configuration setting, but looking to migrate off of there to native postgres pretty soon and was hoping there was some way to have the same setting globally in native postgres. Which is starting to look like is not possible.
On Wed, 2021-03-24 at 19:18 -0400, Tim wrote: > Has anyone ever had to migrate Oracle redwood style dates functionality into Postgres? > Is it possible to set a global custom DateStyle setting?