Hello: I have a flow that selects data from a table and inserts the data into a backup table in another database, This has been working just fine for over 6 months. After I select the data from the source, a function node converts the data into a SQL statement to insert into the target, Today I sta…

[image] dceejay: now 0.1.6 def returns date type for the timestamp. Is it available? I wanted to test this out but it is not showing as an available update.

you dont have to - you can work around this. var dateJS = new Date(m[x].created) var dateYear = dateJS.getFullYear() YOUR ERROR: it is new Date - NOT - new date (case sensitive)

[image] Steve-Mcl: YOUR ERROR: it is new Date - NOT - new date (case sensitive) THANK YOU! That seems to work. Do you think I should create an issue on Github for this or would change be by design?

A minor release would not intentionally introduce a breaking change, so yes, I think you should create an issue.

@colin @Steve-Mcl Very strange - I reverted to 0.1.2 on a test instance of NR and I still get the same error. I did restart NR and confirmed that I the version of node-red-node-mysql is 0.1.2. I was going to create and issue but now I'm not sure what is causing this.

What exactly is it that has changed?

I meant what is it that the SQL node does that it is now different? The code you posted suggested that it used to return a Date object, but now it returns a String.

I think this comes from a naive fix from this thread - Splitting array - from MySQL query I have now tried to do a better object copy in version 0.1.5 so hopefully anything is now preserved, though my simplistic testing always seems to return strings anyway.

[image] Colin: The code you posted suggested that it used to return a Date object, but now it returns a String. Yes - that's what I was hoping to see when I reverted to 0.1.2 but it is typed as "string" now. I put in a debug to get the type and this is what is shows: type of created: string,…

[image] dceejay: I have now tried to do a better object copy in version 0.1.5 so hopefully anything is now preserved, though my simplistic testing always seems to return strings anyway. Unfortunately, it's not working with 0.1.5 either. My table structure is: [Screen Shot 2021-03-21 at 6.05…

Node-RED

Node-RED Forum

Function node - getFullYear error

General

rakgupta 20 March 2021 22:34 13

I'm trying to remember - but the basic platform has not changed. I updated the mySQL node and some other nodes that were showing updates (unfortunately I can't recall which ones).

Topic		Replies	Views
MSSQL Datetime issues General	38	3693	1 March 2020
Node-red and mySQL show different output General	8	1336	23 December 2019
Timestamp in function problems General	12	2900	5 November 2020
How to get date time to mysql General	11	3893	8 February 2021
NodeRED and SQL data fetching problem General	34	3167	14 April 2019

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Function node - getFullYear error

Related topics