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

2020-11-09 Thread raf
On Tue, Nov 10, 2020 at 10:51:02AM +0530, mark armon <1994hej...@gmail.com> wrote: > On Mon, Nov 9, 2020 at 9:44 PM David G. Johnston > wrote: > > > On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hej...@gmail.com> wrote: > > > >> How to set up a schema default date (now) to '2020-01-01'? Whate

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

2020-11-09 Thread David G. Johnston
On Mon, Nov 9, 2020 at 10:21 PM mark armon <1994hej...@gmail.com> wrote: > 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 > That is not presently a feature that PostgreSQL implements. While you can leverage pro

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

2020-11-09 Thread mark armon
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 wrote: > On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hej...@gmail.com> wrote: > >> >> How to set up a schema default

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

2020-11-09 Thread David G. Johnston
On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hej...@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.

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

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