Date Format 9999-12-31-00.00.00.000000

From: Dirk Krautschick <Dirk(dot)Krautschick(at)trivadis(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Date Format 9999-12-31-00.00.00.000000
Date: 2020-10-15 20:58:13
Message-ID: AM0PR05MB6082081F3DB8E97EE9492B0AE9020@AM0PR05MB6082.eurprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

because of a migration from DB2 we have a lot of timestamps like

9999-12-31-00.00.00.000000

What would be the best way to handle this in Postgres also related
to overhead and performance (index usage?).

Or is

TO_TIMESTAMP('9999-12-31-00.00.00.000000', 'YYYY-MM-DD-HH24.MI.SS.US')

the only way? And isn't it possible to define this like NLS parameters in Oracle
system wide?

Thanks

Dirk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2020-10-15 21:12:00 Re: UUID with variable length
Previous Message Dirk Krautschick 2020-10-15 20:49:49 UUID with variable length