Mysql node returns time and date from columns set as DATE

Probably not. JS (currently) has no concept of just a date - there is the Date Object that is the time in milliseconds that has elapsed since the epoch, which is defined as the midnight at the beginning of January 1, 1970, UTC.

But there is no reason you cannot use that in your flows. For example the change node has moment that can convert it to a date string. or you can use a function node to call the various Date.toXxxxx() functions.

The question is really, what are you wishing to do with the date you get from the database? If you wish to show it on a dashboard or pass it somewhere else, then it is probably just a matter of formatting it as you wish.

1 Like