Wappler Version :
Operating System : 5.4.2
Server Model: node
Database Type: mysql 8
Hosting Type:
Perhaps related to: UTC Timezone handling does not apply to subtables
Expected behavior
MySQL8 columns with data type “time”, should be displayed in the browsers local timezone if the DB connection is set to UTC and a formatDate is applied to the value.
Actual behavior
The value is delivered to the client as:
close_time: "16:30:00.000Z"
open_time: "08:00:00.000Z"
And displays nothing when using:
open_time.formatDate('h:mm a')
close_time.formatDate('h:mm a')
Changing to Driver dependent on the db connection produces the desired result;
close_time: "16:30:00"
open_time: "08:00:00"
Community Page
Last updated:
Last updated: