Re: Postgres Date Type Value

[Michael Arnold <myk321@xxxxxxxxx>]

My bad - was referencing the wrong column with PQgetvalue().  With that corrected, get 8332 for 2022-10-25.  So date is an integer day count from POSTGRES_EPOCH_JDATE (2000-01-01).

Thanks for the help!

---------------

On Sun, Dec 18, 2022 at 8:24 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Sat, Dec 17, 2022 at 4:55 PM Michael Arnold <myk321@xxxxxxxxx> 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.