> On 27/04/2023 13:20 CEST gzh wrote:
>
> When the return type is set to oracle.date, there are hours, minutes, and
> seconds of the date value in the SQL execution result.
> Why is there such a difference and how to solve it?
orafce defines oracle.date as timestamp(0) [0] because Oracle's DATE
Thank you very much for your reply.
I did the following two tests and found that the return value of
pg_catalog.date and oracle.date are inconsistent.
â‘ the function was created with return type pg_catalog.date
---
CREATE OR REPLACE FUNCTION to_date(str text) RETURNS pg_catalog.date AS
