Keep `today` as `today` in column default value

mathesar-foundation / mathesar

Web application providing an intuitive user experience to databases.

https://mathesar.org/

GNU General Public License v3.0

2.4k stars 332 forks source link

Keep `today` as `today` in column default value #2754

Open perguth opened 1 year ago

perguth commented 1 year ago

Problem

When selecting today as the default value for a column it sets the default to the current days date.

Proposed solution

When selecting a default value for a column it would be helpful to keep today as meaning "always the date on which the new record will be created" (default CURRENT_DATE in SQL) instead of translating it into the concrete date of today.

Additional context

pavish commented 1 year ago

Supporting dynamic defaults is part of our roadmap. Related to discussion: https://github.com/centerofci/mathesar/discussions/2272.

malikmmoaz commented 1 year ago

hi, has this issue been assigned? if not, you may assign it to me.

rajatvijay commented 1 year ago

Hi @TheHotatoPotato no, this has the label restricted:maintainers