yjryu / UI_Layout star
File name
Commit message
Commit date
yjryu 01-10 08c2192 240110 류윤주 commit UNIX

postgres-interval Build Status Greenkeeper badge#

Parse Postgres interval columns

Install#

$ npm install --save postgres-interval

Usage#

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

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 compliant string.

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

License#

MIT © Ben Drucker