Bug 378284 - Add support to specify current time/date or time stamp as default value for table field
Summary: Add support to specify current time/date or time stamp as default value for t...
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 3.1.0 Alpha
Platform: Other All
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-03-30 17:21 UTC by Jarosław Staniek
Modified: 2017-03-30 17:21 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Jarosław Staniek 2017-03-30 17:21:24 UTC 
Add support to specify current time/date or time stamp as default value for table field.

Supported types could be date/time/datetime. It makes sense to also allow the keywords for text types.

In case of SQLite it is possible through keywords CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP: http://www.sqlite.org/lang_createtable.html#tablecoldef