Datetime in database view shows as generic datetime placeholder / defualt format why?

Hi All

I need some guidance on this and wonder if this is an issue or a limitation of the database view.

So I have a number of fields in the database table which are DateTime type. I simply save the UTC_NOW datetime and in the database view it always shows as ‘1970-01-01 11:00:00’

I am using MYSQL 8 as created with Wappler. Mac user.

datetime
datetime668×700 54.8 KB

I can click on a field to edit it and it shows the correct date and I can add the current time and it saves ok.

datetime-click
datetime-click794×988 146 KB

So it must be how I am saving the current date time maybe?

query
query1350×956 115 KB

Any help would be appreciated.

Community Page
Last updated: