BLUE

Edit File Size: 1.49 KB

/var/www/gtechmarathon2026.bitkit.dk/httpdocs/node_modules/postgres-interval/readme.md

Text Base64

# postgres-interval [![tests](https://github.com/bendrucker/postgres-interval/workflows/tests/badge.svg)](https://github.com/bendrucker/postgres-interval/actions?query=workflow%3Atests)

> Parse Postgres interval columns

## Install

```sh
npm install --save postgres-interval
```

## Usage

```js
var parse = require('postgres-interval')
var interval = parse('01:02:03')
//=> {hours: 1, minutes: 2, seconds: 3}
interval.toPostgres()
// 3 seconds 2 minutes 1 hours
interval.toISOString()
// P0Y0M0DT1H2M3S
```

This package parses the default Postgres interval style. If you have changed [`intervalstyle`](https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-INTERVALSTYLE), you will need to set it back to the default:

```sql
set intervalstyle to default;
```

## API

#### `parse(pgInterval)` -> `interval`

##### pgInterval

*Required*  
Type: `string`

A Postgres interval string.

#### `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](https://en.wikipedia.org/wiki/ISO_8601#Durations) compliant string, for example `P0Y0M0DT0H9M0S`.

Also available as `interval.toISO()` for backwards compatibility.

#### `interval.toISOStringShort()` -> `string`

Returns an [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601#Durations) compliant string shortened to minimum length, for example `PT9M`.

## License

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
index.d.ts	447 B	lrw-r--r--	2025-07-10 12:54:56	Edit Download recursive recursive
index.js	4.25 KB	lrw-r--r--	2025-07-10 12:54:56	Edit Download recursive recursive
license	1.08 KB	lrw-r--r--	2025-07-10 12:54:56	Edit Download recursive recursive
package.json	649 B	lrw-r--r--	2025-07-10 12:54:56	Edit Download recursive recursive
readme.md	1.49 KB	lrw-r--r--	2025-07-10 12:54:56	Edit Download recursive recursive

Directory Contents