Menu ▾ ▴

#1653 (ok 4.5) New data validation feature and datetime type

Needs_decision
resolved
Madhura Jayaratne
None
Low
2015-04-10
2015-04-09
Isaac Bennetch
No

On a 'datetime' column, a valid datetime is "2015-04-09"; MySQL automatically converts this to "2015-04-09 00:00:00". The new jQuery data validation (see https://github.com/phpmyadmin/phpmyadmin/pull/1622) prevents entering the shortened form.

We probably should allow insert when using the shortened form here.

Discussion

  • Isaac Bennetch

    Isaac Bennetch - 2015-04-09
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1,3 +1,3 @@
-When using the new jQuery data validation (see https://github.com/phpmyadmin/phpmyadmin/pull/1622) on a 'datetime' column, a valid datetime is "2015-04-09"; MySQL automatically converts this to "2015-04-09 00:00:00".
+On a 'datetime' column, a valid datetime is "2015-04-09"; MySQL automatically converts this to "2015-04-09 00:00:00". The new jQuery data validation (see https://github.com/phpmyadmin/phpmyadmin/pull/1622) prevents entering the shortened form.

-We probably should allow insert when using the shortened form.
+We probably should allow insert when using the shortened form here.
     

  • Madhura Jayaratne

    Madhura Jayaratne - 2015-04-10
    • assigned_to: Madhura Jayaratne
     

  • Madhura Jayaratne

    Madhura Jayaratne - 2015-04-10
    • summary: New data validation feature and datetime type --> (ok 4.5) New data validation feature and datetime type
    • status: open --> resolved
    • Priority: Normal --> Low