Parse Postgres interval columns
$ npm install --save postgres-interval
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.toISO()
// P0Y0M0DT1H2M3S
parse(pgInterval) -> intervalRequired
Type: string
A Postgres interval string.
interval.toPostgres() -> stringReturns an interval string. This allows the interval object to be passed into prepared statements.
interval.toISOString() -> stringReturns an ISO 8601 compliant string.
Also available as interval.toISO() for backwards compatibility.
MIT © Ben Drucker