postgres-date

What is postgres-date?

The postgres-date npm package is designed to parse and handle dates in PostgreSQL format. It provides functionalities for converting PostgreSQL date and timestamp strings into JavaScript Date objects. This can be particularly useful when working with PostgreSQL databases in Node.js applications, ensuring that date and timestamp data is correctly handled and manipulated.

What are postgres-date's main functionalities?

Parsing PostgreSQL date strings

This feature allows the conversion of PostgreSQL date strings into JavaScript Date objects. It's useful for handling date information retrieved from a PostgreSQL database.

"const parseDate = require('postgres-date');
const dateString = '2023-04-01';
const dateObject = parseDate(dateString);
console.log(dateObject); // Outputs a JavaScript Date object for 2023-04-01"

Parsing PostgreSQL timestamp strings

Similar to parsing date strings, this feature enables the parsing of PostgreSQL timestamp strings, including those with time information, into JavaScript Date objects.

"const parseDate = require('postgres-date');
const timestampString = '2023-04-01 12:00:00';
const dateObject = parseDate(timestampString);
console.log(dateObject); // Outputs a JavaScript Date object for 2023-04-01 12:00:00"

Other packages similar to postgres-date

moment

Moment is a widely used package for parsing, validating, manipulating, and formatting dates. It supports multiple date formats and locales. Compared to postgres-date, Moment offers a broader range of functionalities beyond just parsing PostgreSQL date strings, including operations on dates and extensive formatting options.

date-fns

date-fns is a modern JavaScript date utility library offering a comprehensive set of date manipulation functions. It provides functions for parsing, formatting, and manipulating dates. Unlike postgres-date, which is focused on PostgreSQL date strings, date-fns offers a wide array of utilities that can be used with various date formats and is designed with a modular approach.

luxon

Luxon is a powerful library for dealing with dates and times in JavaScript. It offers capabilities for parsing, formatting, manipulating, and querying dates and times. Luxon is built on the Intl API and provides time zone support. While postgres-date is specialized for PostgreSQL date strings, Luxon provides a more comprehensive solution for date and time handling, including support for internationalization.

README

postgres-date

Postgres date output parser

This package parses date/time outputs from Postgres into Javascript Date objects. Its goal is to match Postgres behavior and preserve data accuracy.

If you find a case where a valid Postgres output results in incorrect parsing (including loss of precision), please create a pull request and provide a failing test.

Supported Postgres Versions: >= 9.6

All prior versions of Postgres are likely compatible but not officially supported.

Install

npm install --save postgres-date

Usage

const parse = require('postgres-date')
parse('2011-01-23 22:15:51Z')
// => 2011-01-23T22:15:51.000Z

API

parse(isoDate) -> date

isoDate

Required
Type: string

A date string from Postgres.

Releases

The following semantic versioning increments will be used for changes:

• Major: Removal of support for Node.js versions or Postgres versions (not expected)
• Minor: Unused, since Postgres returns dates in standard ISO 8601 format
• Patch: Any fix for parsing behavior

License

MIT © Ben Drucker