Time values not formatted to local time when using UTC

[mebeingken]

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"

[mebeingken]

bump

[patrick]

It seems that App Connect datetime parser doesn’t recognize the UTC time string.

I’ve updated the parser, please test with the following update: dmxAppConnect.zip (26.7 KB)

[Teodor]

Fixed in Wappler 5.4.3