moment-db

Moment implementation for formatting Dates into ANSI compatible strings suitable for database consumption.

npm install moment-db

import MomentDB from 'moment-db.js'

Assume the date/time notation below.

Notation	Description
YYYY	4-digit year
MM	2-digit month (01 to 12)
DD	2-digit day (01 to 31)
HH	2-digit hour (00 to 23)
MI	2-digit minute (00 to 59)
SS	2-digit second (00 to 59)
FFF	Fraction of a second (1 to 9 digits)
TH	2-digit hour offset (-12 to 14)
TM	2-digit minute offset (00 to 59)
YEARS	Number of years (max of 9999)
DAYS	Number of days (max of 3652047)

Using the forementioned notation, the following database data types can be used to construct ANSI compliant date/time formats:

Data Type	Format	Example
DATE	YYYY-MM-DD	2030-01-31
TIME (w/o time zone)	HH:MI:SS.FFF	12:01:20.903
TIME (with time zone)	HH:MI:SS.FFF [+|-]TH:TM	12:01:20.903 -07:00
TIMESTAMP (w/o time zone)	YYYY-MM-DD HH:MI:SS.FFF	2030-01-31 12:01:20.903
TIMESTAMP (with time zone)	YYYY-MM-DD HH:MI:SS.FFF [+|-]TH:TM	2030-01-31 12:01:20.903 -07:00
INTERVAL YEAR TO MONTH	[+|-]YEARS-MM	+130-01
INTERVAL DAY TO SECONDS	[+|-]DAYS HH:MI:SS.FFF	-47482 12:01:20.903

Converting ES Dates

Each static MomentDB function accepts a Date that can be formatted into an ANSI compliant date/time format suitible for database consumption.

DATE

const date = MomentDB.date(new Date());
// assumming date, the output would be something like:
// 2030-01-31

TIME (w/o time zone)

const time = MomentDB.time(new Date(), true);
// assumming date, the output would be something like:
// 12:01:20.903

TIME (with time zone)

const time = MomentDB.time(new Date());
// assumming date/timezone, the output would be something like:
// 12:01:20.903 -07:00

TIMESTAMP (w/o time zone)

const ts = MomentDB.timestamp(new Date(), true);
// assumming date, the output would be something like:
// 2030-01-31 12:01:20.903

TIMESTAMP (with time zone)

const ts = MomentDB.timestamp(new Date());
// assumming date/timezone, the output would be something like:
// 2030-01-31 12:01:20.903 -07:00

INTERVAL (year to month)

const date1 = new Date(Date.UTC(1900, 00, 01)), date2 = new Date();
const monthDate = new Date();
monthDate.setMonth(0);
const interval = MomentDB.intervalYearToMonth(date1, date2, monthDate);
// output (assuming we are in year 2030):
// +130-01

INTERVAL (day to second)

const date1 = new Date(), date2 = new Date(Date.UTC(1900, 00, 01));
const timeDate = new Date();
const interval = MomentDB.intervalDayToSecond(date1, date2, timeDate);
// output (assuming we are in year 2030 and the time is the as indicated in timeDate):
// -47482 12:01:20.903

Converting formatted dates/times into ES Dates

Each static MomentDB function accepts a string returned from prior call to one of the string conversion functions that will be converted back into a Date.

DATE

const date = MomentDB.date('2030-01-31');
const iso = date.toISOString();
// outputs a Date with the date set as UTC
// 2030-01-31T00:00:00.000Z

TIME (w/o time zone)

const time = MomentDB.time('12:01:20.903');
const iso = time.toISOString();
// outputs a Date with the time set as UTC
// iso output (date defaults to 0000-01-01):
// 0000-01-01T12:01:20.903Z
 
// can also remove the timezone, if needed:
const time2 = MomentDB.time('12:01:20.903 -07:00', true);
const iso2 = time2.toISOString();
// outputs a Date with the time set as UTC (no timezone)
// iso2 output (date defaults to 0000-01-01):
// 0000-01-01T12:01:20.903Z

TIME (with time zone)

const time = MomentDB.time('12:01:20.903 -07:00');
const iso = time.toISOString();
// outputs a Date with the time set with the indicated zone
// iso output (date defaults to 0000-01-01):
// 0000-01-01T19:29:38.903Z

TIMESTAMP (w/o time zone)

const ts = MomentDB.timestamp('2030-01-31 12:01:20.903');
const iso = ts.toISOString();
// outputs a Date with the date/time set as UTC
// iso output:
// 2030-01-31T12:01:20.903Z
 
// can also remove the timezone, if needed:
const ts2 = MomentDB.timestamp('2030-01-31 12:01:20.903 -07:00', true);
const iso2 = ts2.toISOString();
// outputs a Date with the date/time set as UTC (no timezone)
// iso2 output:
// 2030-01-31T12:01:20.903Z

TIMESTAMP (with time zone)

const ts = MomentDB.timestamp('2030-01-31 12:01:20.903 -07:00');
const iso = ts.toISOString();
// iso output:
// 2030-01-31T19:01:20.903Z

INTERVAL (year to month)

const date = MomentDB.intervalYearToMonth('+130-02');
const iso = date.toISOString();
// iso output (assuming the current year is 2030):
// 2160-02-01T00:00:00.000Z
 
// can also pass a reference date for the year instead of the default current date
const date2 = MomentDB.intervalYearToMonth('+130-02', new Date(Date.UTC(2030)));
const iso = date.toISOString();
// iso output (assuming today is 2030-02-03 and time in UTC is as indicated):
// 2160-02-01T00:00:00.000Z

INTERVAL (day to second)

const date = MomentDB.intervalDayToSecond('-47482 12:01:20.903');
const iso = date.toISOString();
// iso output (assuming today is 2030-02-03 and time in UTC is as indicated):
// 1900-02-03T12:01:20.903Z
 
// can also pass a reference date to use instead of the default current date
const date2 = MomentDB.intervalDayToSecond('-47482 12:01:20.903', new Date(Date.UTC(2030, 1, 3)));
const iso = date.toISOString();
// iso output (assuming today is 2030-02-03 and time in UTC is as indicated):
// 1900-02-03T12:01:20.903Z