From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Tim <timfosho@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Creating redwood datestyle in Postgres 12
Date: Thu, 25 Mar 2021 18:02:03 +0100
Message-ID: <77f369d02a34bdd1d1386227f1ec2d74d865aab4.camel@cybertec.at> (raw)
In-Reply-To: <CAKhLO5i-PJdeX2q8eEzYVs91bzw1bDJxaSL_tD96XhnmGVAJfg@mail.gmail.com>
References: <CAKhLO5jDy8bMop66WU8cNUFcfSuL1==FyGvawKZT-CC2FYuZXQ@mail.gmail.com>
<5273bd68ae53e76fb592249ba05433b4bb645660.camel@cybertec.at>
<CAKhLO5i-PJdeX2q8eEzYVs91bzw1bDJxaSL_tD96XhnmGVAJfg@mail.gmail.com>
On Thu, 2021-03-25 at 08:38 -0400, Tim wrote:
> 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.
I concur.
You should use "to_char" in your queries or format timestamps in the client application.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, timfosho@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Creating redwood datestyle in Postgres 12
In-Reply-To: <77f369d02a34bdd1d1386227f1ec2d74d865aab4.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox