Postgres Pro
Downloads
Home   >   mailing lists

Re: How to set up a schema default date to '2020-01-01'? - Mailing list pgsql-general

From mark armon
Subject Re: How to set up a schema default date to '2020-01-01'?
Date
Msg-id CACh77r65RJU0+YDZWxbwEuGU6gYf18AUjXcijRrqN+YNm=d0Qw@mail.gmail.com
Whole thread Raw
In response to Re: How to set up a schema default date to '2020-01-01'?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: How to set up a schema default date to '2020-01-01'?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: How to set up a schema default date to '2020-01-01'?  (raf <raf@raf.org>)
List pgsql-general
Tree view

like I create a schema: test, I want the default date to 2020-01-01, so when I do

select test.now;

the result is 2020-01-01



On Mon, Nov 9, 2020 at 9:44 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hejian@gmail.com> wrote:

How to set up a schema default date (now) to '2020-01-01'?  Whatever timezone would be OK. 

What is a "schema default" (date or otherwise)?

David J.

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: initdb --data-checksums
Next
From: "David G. Johnston"
Date:
Subject: Re: How to set up a schema default date to '2020-01-01'?