Custom data type handlers

[anton-johansson]

I'm loading DATE, DATETIME and DATETIMEOFFSET(3) from my SQL server database. I've only tested DATETIME with node-mssql so far, but it looks like it's parsed into a native JavaScript Date, which makes sense. However, I would want to change this so that...:

• DATE (sql.Date) into js-jodas LocalDate
• DATETIME (sql.DateTime) into js-joda's LocalDateTime
• DATETIMEOFFSET(x) (sql.DateTimeOffset [scale]) into js-joda's ZonedDateTime

Is there a way to register custom handlers for these types?

[dhensby]

At the moment there's no way to customise the parsed type.

This would be a nice feature to add (custom typing or type resolution); the basis of it is there as we run the rows through "value correction"

node-mssql/lib/tedious/request.js

Lines 161 to 171 in 5923bba

	const valueCorrection = function (value, metadata) {
	if ((metadata.type === tds.TYPES.UDT) && (value != null)) {
	if (UDT[metadata.udtInfo.typeName]) {
	return UDT[metadata.udtInfo.typeName](value)
	} else {
	return value
	}
	} else {
	return value
	}
	}

But this isn't extensible at the moment.

[anton-johansson]

@dhensby Thanks for the quick response. Glad to hear it's prepared in a good way!

I would happily attempt working on a PR for this, if you'd be willing to guide me a bit. How would you want this to be configured? How would one register value correction handlers for a certain type?