Database changes, but "Nothing to do"

[mhartwig]

I have two changes to ready to update in my Postgres db. I unchecked the timezone box on two fields.

When clicking update I get “Nothing to do”

[fdgfdgfdg]

There’s something wrong with postgresql date types

I made a report about it here

Date-time type displaying as Timestamp

Wappler Version : 3.20 Operating System : OSX 10.15 Expected behavior When I choose Datetime option it should display as that not another type. Actual behavior When I save it appears to convert into timestamp. It also checks the ‘add timezone’ option everytime even when I deselect it. [image] When I save an entry with unix timestamp it tells me the field is datetime. [image] Now saving as datetime it works fine, so just something cosmetic but I think it stops me from using a default val…

So I think it’s not really adding the timezone option and gets confused.

[mhartwig]

Maybe you can help. I am just trying to save the current utc time

and save in postgres. I either get the below issue:

or and out of range issue.

[fdgfdgfdg]

My understanding of Wappler and general programming is not that great so perhaps someone else can help you.

When I save users from server action oauth into postgres database, there is an option for NOW. This saves utc datetime so I’m not sure if moment is necessary.