{"repo":"bendrucker/postgres-interval","free":true,"listed":false,"github":"https://github.com/bendrucker/postgres-interval","clone":"git clone https://github.com/bendrucker/postgres-interval.git","description":"Parse Postgres interval columns","language":"JavaScript","stars":38,"topics":["postgresql","nodejs"],"license":"MIT","category":"databases-storage","readme_excerpt":"postgres-interval Parse Postgres interval columns Install Usage This package parses the default Postgres interval style. If you have changed intervalstyle , you will need to set it back to the default: API parse(pgInterval) - interval pgInterval Required Type: string A Postgres interval string. This package is focused on parsing Postgres outputs. It optimizes for performance by assuming that inputs follow the default interval format. It does not perform any validation on the input. If any interval field is not found, its value will be set to 0 in the returned interval . interval.toPostgres() - string Returns an interval string. This allows the interval object to be passed into prepared statements. interval.toISOString() - string Returns an ISO 8601 compliant string, for example P0Y0M0DT0H9M0S . Also available as interval.toISO() for backwards compatibility. interval.toISOStringShort() - string Returns an ISO 8601 compliant string shortened to minimum length, for example PT9M . interval.toTemporalDuration() - Temporal.Duration Returns a Temporal.Duration representing the interval. Requires globalThis.Temporal . It ships unflagged in Node 26+. On older runtimes, install a polyfill such as @js-temporal/polyfill and assign it to globalThis.Temporal . The method throws if Temporal is unavailable. Postgres mixed-sign intervals (e.g. 1 mon -1 days ) throw a RangeError . Temporal.Duration requires all fields to share a single sign, which these intervals violate. The Temporal types ar","default_branch":null,"files":null,"tree":[],"storefront":"/r/bendrucker","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/bendrucker/postgres-interval/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}