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.
Thank you!
Tim A
On Thu, Mar 25, 2021 at 12:06 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
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?
What would that be?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com