ISO8601 time in DD-MM-YYYY

[Lestat De la Morte]

    Hi guys,

      

i need a little help on how to show time in DD-MM-YYYY in a table in the dashboard.  I'm having this flow where an array comes from a Mysql query:

 And in the dashboard it shows like this:

      

So i'd like to have my dates whitout the HH-MM-SSZ. I tried all sorts of things to no avail, 

Thanks again.                    

[Julian Knight]

Just use my moment node, you can format your date anyway you like then.

On Monday, 27 March 2017 20:12:43 UTC+1, Lestat De la Morte wrote:

    Hi guys,

      

i need a little help on how to show time in DD-MM-YYYY in a table in the dashboard.  I'm having this flow where an array comes from a Mysql query:

n.                    

[Lestat De la Morte]

Thanks Julian i tried it earlyer but it gives me: 

The input property was NOT a recognisable date. Output will be a blank string

and i loose everything in my table... 

But it works great with just an inject node though. iconfigured it as follow: 

I'm missing something obviously...

[Julian Knight]

Ah, maybe I should have looked more closely. You are sending a table. It's not set up for that.

Can you share the output from the db query node? Then we can work out the best way. My node only uses moment.js under the skin.

[Max Hadley]

ISO format has YYYY-MM-DD and not DD-MM-YYYY - is this your problem?

On Monday, 27 March 2017 20:51:55 UTC+1, Lestat De la Morte wrote:

[Julian Knight]

Actually, I must be tired. The obvious answer is for you to adjust your SQL query to give you the dates and times in the format you want in the first place.

http://www.mysqltutorial.org/mysql-date_format/

[Lestat De la Morte]

Yahoo! Thanks for the tip Jordan, i nailed it directly within the query with the MYSQL DATE_FORMAT function.

msg.topic = "SELECT DATE_FORMAT(`time_deb`, '%d-%m-%Y') AS jour, pompe, SEC_TO_TIME(SUM(duration))AS Hrs, sum(departs)AS departs from `vue_5` where `time_deb` is not NULL group by  DATE_FORMAT(`time_deb`, '%d-%m-%Y'), pompe order by  DATE_FORMAT(`time_deb`, '%d-%m-%Y'), pompe ASC LIMIT 65 " ;

return msg;

and here it is, nice and clean with borders and some css to put the values in the center of the cell.

Le lundi 27 mars 2017 15:12:43 UTC-4, Lestat De la Morte a écrit :

[Lestat De la Morte]

No Max, that was just a typo, in french we use that order ex: 27 march 2017.