Re: How to set up a schema default date to '2020-01-01'?

From: mark armon <1994hejian(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to set up a schema default date to '2020-01-01'?
Date: 2020-11-10 05:21:02
Message-ID: CACh77r65RJU0+YDZWxbwEuGU6gYf18AUjXcijRrqN+YNm=d0Qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hejian(at)gmail(dot)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.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-11-10 05:29:10 Re: How to set up a schema default date to '2020-01-01'?
Previous Message Michael Paquier 2020-11-10 02:04:47 Re: initdb --data-checksums