Handling SQL date as string with node-mssql

Question

I'm using node-mssql to get rows from a table that includes a date column (YYYY-MM-DD). I want to pass the date to a client application as a string in that same format. node-mssql is creating date objects, which I'm having to convert and slice at significant cost to get the format that I started with. sql.map.register(String, sql.Date) doesn't seem to work here (or I'm using it wrong). Is there a way to change how node-mssql handles the SQL date data type?

Joey Lakerdas-Gayle · Accepted Answer · 2020-08-15 19:28:45Z

3

I'm having the same problem. sql.map.register is only for converting JS types to SQL types and I don't think there is any way to avoid SQL Date fields being converted into JS Date objects with node-mssql alone. I just changed my SQL query to convert to a formatted varchar instead of a Date type, e.g.: convert(varchar, birthday, 105) as dob.

answered Aug 15, 2020 at 19:28

Joey Lakerdas-Gayle

312 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Handling SQL date as string with node-mssql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related