Time values not formatted to local time when using UTC

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: