On 25/03/2021 12:38, Tim wrote:
Its a native ORACLE date formatting which shows like this: 08-JAN-99
04:05:06 set in the datestyle config param.
Currently running on EDB Advanced Server 12 which allows it as a
datestyle configuration setting, but looking to migrate off of there
to native postgres pretty soon and was hoping there was some way to
have the same setting globally in native postgres. Which is starting
to look like is not possible.
Could you create views/rules/triggers to do the conversions for you?
Eg, if you have a table 'invoices', then create a view 'invoices_' and
set it to set your formatting, and use rules to allow updates/inserts
via that view. That might need less changes to the code.
--
Paul
Paul Smith Computer Services
support@xxxxxxxxxx - 01484 855800
--
Paul Smith Computer Services
Tel: 01484 855800
Vat No: GB 685 6987 53
Sign up for news & updates at http://www.pscs.co.uk/go/subscribe
