Bug #96962 Request: UI DateTime Picker with now button

• Submitted: 22 Sep 2019 6:28
• Modified: 1 Oct 2019 7:40
• Reporter: Adam M
• Status: Verified
• Category: MySQL Workbench
• Severity: S4 (Feature request)
• Version: 8.0.17
• OS: Any
• CPU Architecture: Any
• Tags: datetime picker, timestamp, UI

[22 Sep 2019 6:28] Adam M

Description:
Currently timestamp, datetime, date, and time fields do not have a picker UI/UX element. At times if a field is a non-null field it causes a pain to fill in the information. PhpMyAdmin has a datetime picker where you can specify now. I think is a major missing feature that should garner some priority. It would be nice if the UI had a button where you can pick the date and time or choose "now" and use the current datetime.

ERROR 1292: 1292: Incorrect datetime value: 'now()' for column 'timestamp' at row 1

Thank you for your consideration.

How to repeat:
1) Create a table
2) Add a datetime field with NN (Non-Null) attributes
3) Insert new row 30 times using the current datetime.
4) Imagine doing this with larger data input manually.

5) Click on form editor view.

Suggested fix:
Add UI element DateTime Picker dialog to datetime/timestamp fields.
Allow 'now()' parameter in the form editor view and grid views.

[26 Sep 2019 20:14] Adam M

Updated synopsis

[1 Oct 2019 7:40] MySQL Verification Team

Hello Adam Morgan,

Thank you for the reasonable feature request!

Regards,
Ashwini Patil