Hello! I am trying to insert the current date into a field using an SQL statement. I have tried with GETDATE(), NOW() and the system variable “system time” but none seems to work.
Which SQL flavor does Nocobase use? Which function can I use to insert the current date? Thanks!
I reply to myself. Nocobase uses SQLite.
I had some success using specific SQLite functions such as julianday() and timediff().