Wappler Version : 5.1.9
Operating System : Mac OS
Server Model: NodeJS
Database Type: Postgres
Hosting Type: Docker
Expected behavior
What do you think should happen?
Using the ::date, as created_at::date should return only the date of the timestamp field.
Actual behavior
What actually happens?
It’s not applying the function, returning the full timestamp field.
How to reproduce
Create a custom query, select one timestamp field an then apply the ::date function.
E.g: select created_at::date from table
::date is working fine on pgAdmin, but not on Wappler.
PG Admin return
Wappler return
I tried to change the type on custom query schema to date
and to date and time
, but without success.
Any clue?
Thanks!
Community Page
Last updated:
Last updated: