Re: TO_DATE function between PostgreSQL 8.2 and 9.4 - Mailing list pgsql-general

From David G. Johnston
Subject Re: TO_DATE function between PostgreSQL 8.2 and 9.4
Date
Msg-id CAKFQuwZCDEBBOkW3H16UneUxffh3yK1CMCtGw7i=dT4ETiPSJA@mail.gmail.com
Whole thread Raw
In response to TO_DATE function between PostgreSQL 8.2 and 9.4  (gzh <gzhcoder@126.com>)
List pgsql-general
On Tue, May 17, 2022 at 8:55 AM gzh <gzhcoder@126.com> wrote:

--PostgreSQL 9.4

---------------

SELECT to_date(now() + '-7day', 'YYYY-MM-DD');


--------------------------------------------------------------------------------

ERROR:  function to_date(timestamp with time zone, unknown) does not exist

LINE 1: SELECT to_date(now() + '-7day', 'YYYY-MM-DD')

                ^

********** Error **********


Is there any easy way to maintain compatibility?



You could try creating a user function named "to_date" with (timestamptz, text) as the signature and then inside the function cast the first argument to text explicitly before invoking the built-in to_date(text, text) function and returning its result.

You may have to deal with namespace/search_path issues though...
David J.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: TO_DATE function between PostgreSQL 8.2 and 9.4
Next
From: John W Higgins
Date:
Subject: Re: TO_DATE function between PostgreSQL 8.2 and 9.4