Search Postgresql Archives

Re: Postgres Date Type Value

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Postgres Date Type Value
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Sat, 17 Dec 2022 17:24:21 -0700
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAMOVWRiUuVQ6hHqAFSmnto3JQ2LRCu6jGmSYL_jvN7FXic=jbg@mail.gmail.com>
References: <CAMOVWRiUuVQ6hHqAFSmnto3JQ2LRCu6jGmSYL_jvN7FXic=jbg@mail.gmail.com>

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Postgres Date Type Value
  - From: Michael Arnold

References:
- Postgres Date Type Value
  - From: Michael Arnold

Prev by Date: Re: Postgres Date Type Value
Next by Date: Re: Postgres Date Type Value
Previous by thread: Re: Postgres Date Type Value
Next by thread: Re: Postgres Date Type Value
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux