Convert UTC Time to Local Time for an Array of Data

Wappler General
1

In a server action, I am reading multiple records from the database, each of which contain a time stored in UTC. So the data struture is like this:

message_send_record
   time_sent in UTC
   other_information

I want the output of the server action to be like this:

message_send_record
   time_sent in local time
   other_information

How do I do this in Wappler?

2

@Teodor, is this something you can guide me with? :slight_smile:

3

It would be better to handle it on the SQL side I think.
I’m not sure if there would be an easy way to do this on the server action end.
You can also convert on the client side, but that is not your requirement I assume.

So, in MySQL, there is this function to do convert stored date time values. You can send the local time zone as param to the server action GET/POST… then use that to maybe create a custom query with params.

If you are willing to do this on the client side, you can create a date formatter using moment JS to convert time to local time zone.
So, wherever you bind the date time value, you will use something like time_sent.getLocalTime().

Here is an example of formatter I use to convert date time to Sydney/Australia:
//DMX formatters to get Australian Sydney Timezone DateTime dmx.Formatter('string', 'datetimeNow', function (val) { // var today = new Date(); let today = new Date().toLocaleString("en-US", { timeZone: "Australia/Sydney" }); return moment(new Date(today)).format("YYYY-MM-DDTHH:mm:ss"); });

PS: I am not sure why I use en-US, but it just works, so didn’t dig into it. :sweat_smile:

1 Like
4

@Teodor, is there a way to do what I am looking for in Wappler?

I’d rather stay in Wappler than use mySQL or moment…

5

I will have a need for this too, I was going to suggest Moment.js Timezone as it’s already half integrated but after seeing the depreciation notice the other day maybe it’s best to look for an alternative library.