Convert datepicker to YYYY-MM-DD Format

[Garry Hayne]

Hi,

I am trying to get the output of the date picker into a query of a Mysql database. How can I convert it into the "YYYY-MM-DD" format?

Regards, Garry

 

[Dave C-J]

Under the Dashboard - Site tab

for additional info click the i icon

[Dave C-J]

Ah - no that's just visually :-) you need to convert the timestamp emitted into whatever format you want ... You can either use a function node and the Date functions https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Global_Objects/Date

or this node may help https://www.npmjs.com/package/node-red-contrib-moment