Postgres Pro
Downloads
Home   >   mailing lists

Re: Intervals and ISO 8601 duration - Mailing list pgsql-general

From Tom Lane
Subject Re: Intervals and ISO 8601 duration
Date
Msg-id 918553.1673673651@sss.pgh.pa.us
Whole thread Raw
In response to Re: Intervals and ISO 8601 duration  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-general
Tree view 
Tatsuo Ishii <ishii@sraoss.co.jp> writes:
> I am not sure if I fully understand what you want to do here but I
> guess you can extract "93600000" part easier using "EPOCH" of EXTRACT
> function.

EPOCH merges all three of the primitive fields together, which
is not what Ken is after IIUC.

            regards, tom lane

pgsql-general by date:

Previous
From: qihua wu
Date:
Subject: synchronized standby: committed local and waiting for remote ack
Next
From: Adrian Klaver
Date:
Subject: Re: Intervals and ISO 8601 duration