Hi, Am Mittwoch, dem 25.02.2026 um 23:30 -0700 schrieb David G. Johnston: > On Wednesday, February 25, 2026, yangyz <[email protected]> wrote: > > > > In order to enhance the compatibility > > between Oracle and PostgreSQL, I implemented it. > > > > This isn’t all that appealing to me. There isn’t really a goal of > increased compatibility’s aside from with the SQL Standard > (extensions can > accept that burden IMO). And the utility of preventing people from > having > to explicitly write the word ‘day’ is marginal. And given the > already > numerous ways to combine data types in date/time I hesitate to add > yet more.
And there's the orafce extension[1] which adds extensive oracle datetime compatibility to Postgres (including a more or less compatible oracle.date type). This is far more useful since it also adds many of the Oracle functions for datetime operations, too (like sysdate, ...). [1] https://github.com/orafce/orafce -- Thanks, Bernd
