Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Info om utløpsdato på prosjekter

Code Block

language	sql

MariaDB [keystone]> select name, extra from project where domain_id=(SELECT foo from barid from project WHERE is_domain=1 AND name='NTNU') AND DATEDIFF(STR_TO_DATE(JSON_VALUE(extra,'$.expiry'),'%d.%m.%Y'),NOW()) <= 30;