Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPHGT-0000U2-Bv for pgsql-admin@arkaria.postgresql.org; Thu, 25 Mar 2021 04:06:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lPHGR-0005Ys-Ey for pgsql-admin@arkaria.postgresql.org; Thu, 25 Mar 2021 04:06:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPHGR-0005Yj-3H for pgsql-admin@lists.postgresql.org; Thu, 25 Mar 2021 04:06:31 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lPHGJ-0000DS-W5 for pgsql-admin@lists.postgresql.org; Thu, 25 Mar 2021 04:06:30 +0000 Received: by mail-wm1-x329.google.com with SMTP id d8-20020a1c1d080000b029010f15546281so2317022wmd.4 for ; Wed, 24 Mar 2021 21:06:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=lLG7x4d/I20E9X+IeeRo5NQp0hJsR1DHj2TaijHqalE=; b=YVDmaR0ZKFqmL//+Yvo3UvDyXjgX5g2mRQp7VIbVW1TVt/i8CmqllfZWbCWDytbpgy fAloGudbh1MI8Vml6yD4Ytdq/3HygT+GPgmgyusNgK7HdS2KRzEcrKZW3fGGmDs04L6R Xp8PYOKCocUElgoEXdBcC1TdJtaMG4IO6sO7DUFON4/3GR0jwZlHB4pN5FLPxszFkyCy Di5lTKlnBoOdlN3TnyQ789liG9iJ/Wk7T7LKhfvUStlKil+SyyXOnvVdwjDs+NrinSSJ BaoVVAvzhHXw6W8qsbSsqZkR9H5GBFaYFQ7g/z4o0ahl/XteBxpNG2C2YrHXytuhRnK7 Oigg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=lLG7x4d/I20E9X+IeeRo5NQp0hJsR1DHj2TaijHqalE=; b=Nx6BpFqg2FfocTytqF7pU1NiMphQQmqAWogqzUgkXixo+IUOMrZpUJsgGYuObw3os4 zEnkLnJtEAOK2oAwnJl+YH3+hh5VGnhrMb6Hu6VUYbQ42x6+E+stNVmmw3WSxenfTfyD Em6VgvFxU/jwyYw3NKyMF/K08100aeCmvw8UCAhLgYZgN9vsk/l6LxJLT7E0BZ7fhDCD YbOD7AER6U3ZCQGwEwxZH2zcUSf5IhiulUlDiIrughFTby3DAA0nFVjf9is1CyU7PrES Iq40ZbLUQImQxcb2MNH47iUXfAEGddsLfDbDO2b+fgO111yNisBLg5u/2hjwoENCrhml 9cGA== X-Gm-Message-State: AOAM530WPn/cH4alv7VzRfH4k1BOMubtyFeqpv4FCHF8/mD8fXNMDf0R TGXrjNDJitXZsChmhAtgWNu//w== X-Google-Smtp-Source: ABdhPJwY+zuIM5vXdifPF2OQCy9Ifc0nXCzTHbLFuSnLdPzsd3GmEAamT2cFIqXuW4TvA62UcxgbWw== X-Received: by 2002:a1c:400b:: with SMTP id n11mr5635671wma.167.1616645181916; Wed, 24 Mar 2021 21:06:21 -0700 (PDT) Received: from localhost.localdomain ([86.56.204.198]) by smtp.gmail.com with ESMTPSA id i3sm5595098wra.66.2021.03.24.21.06.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Mar 2021 21:06:21 -0700 (PDT) Message-ID: <5273bd68ae53e76fb592249ba05433b4bb645660.camel@cybertec.at> Subject: Re: Creating redwood datestyle in Postgres 12 From: Laurenz Albe To: Tim , pgsql-admin@lists.postgresql.org Date: Thu, 25 Mar 2021 05:06:21 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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