Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres Date Type Value - Mailing list pgsql-general

From David G. Johnston
Subject Re: Postgres Date Type Value
Date
Msg-id CAKFQuwaz7duhZuwPA8JFX74tz56qR6kcF9-z=VJNTUgsTudd0Q@mail.gmail.com
Whole thread Raw
In response to Postgres Date Type Value  (Michael Arnold <myk321@gmail.com>)
Responses Re: Postgres Date Type Value
List pgsql-general
Tree view
On Sat, Dec 17, 2022 at 4:55 PM Michael Arnold <myk321@gmail.com> wrote:

How do I interpret the 4 bytes of postgresql 'date' value?

See date2j and j2date in datetime.c

timestamp.h has the relevant constant Tom refers to (POSTGRES_EPOCH_JDATE)


David J.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres Date Type Value
Next
From: Michael Arnold
Date:
Subject: Re: Postgres Date Type Value