INTERNAL_SERVER_ERROR when try to use $NOW(<adjustment>) $NOW(-1 year), $NOW(+2 hours)

[hermesalvesbr]

Preflight Checklist

• I have completed all Troubleshooting Steps.
• I'm on the latest version of Directus.
• There's no other issue that already describes my problem.

Describe the Bug

[INTERNAL_SERVER_ERROR] alter table "individuo" alter column "nascimento" set default '$NOW(-1 year)' - invalid input syntax for type date: "$NOW(-1 year)"
content_copy

To Reproduce

I'm trying to use $NOW(-1 year) like docs: https://docs.directus.io/reference/filter-rules/#dynamic-variables

Just works without

[INTERNAL_SERVER_ERROR] alter table "individuo" add column "nascimentotime" timestamptz null default '$NOW(-1 year)' - invalid input syntax for type timestamp with time zone: "$NOW(-1 year)"
content_copy

I have tried with timestamp, date and datetime.

What version of Directus are you using?

v9.0.0-rc.88

What version of Node.js are you using?

node --version v16.5.0

What database are you using?

Postgres 13

What browser are you using?

Chrome

What operating system are you using?

macOS, Windows

How are you deploying Directus?

Docker

[rijkvanzanten]

@hermesalvesbr Where are you using this? It's trying to set it as the default value 🤔

[hermesalvesbr]

Yes, i did some wrong?

[rijkvanzanten]

Ah yeah, those dynamic variables are used in the filter rules, f.e. in filters, permissions, validation, etc. The default value under schema is the default value used for the database column.