Help - MQTT JSON reformat date field prior to insert into mySQL

[Duncan-Hill]

I have an MQTT subscription which outputs parsed JSON into a function that reformats and outputs a message:

• MQTT > Function 'Reformat Message' > Function 'Create SQL' > mySQL connection

The challenge I'm facing is reformatting the JSON date into a mySQL datetime value, I've found the moments formats which is correctly formatting the date but I'm struggling on how to either update the date value or join the data:

• MQTT > Function Moments > Function 'Reformat Message' > Function 'Create SQL' > mySQL connection *** The moments function only outputs the date and not the original MQTT data

• MQTT > Function 'Reformat Message' > JOIN >Function 'Create SQL' > mySQL connection
  > Function Moments --------------> *** The join is not inserting correctly formatted data

The only way I have managed to get this to work is as follows:

• MQTT > Function 'Reformat Message' > JOIN >Function 'Create SQL' > mySQL connection
  > Function Moments > GLOBAL value *** The Create SQL function then uses the GLOBAL value

Is there a better way to achieve what I need to do, reformat date, my concern with my working solution relates to when the GLOBAL value is set, will this be set before the Create SQL is run?

[E1cid]

you could probably reformat the data with a JSONata expression in a change node, or JS in a function node, i doubt you would need a join. It would help if you supplied an example (text not an image) of the incoming data, and how you wanted it formatted.