Announcement

Collapse
No announcement yet.

Timepicker not match to MySQL

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Timepicker not match to MySQL

    Problem : Time in field that use Timepicker not match to MySQL.
    Step1: I set 'Data Type' of the field to 'Time' and 'Values format' -> 'Display' to 'hhmm'. (image name: TSstep1.jpg)
    Step2: 'Run' and use time picker, it's OK. (image name: TSstep2.jpg)
    Step3: Check in MySQL, time value should be 'XX:XX:00' not '00:XX:XX'. (image name: TSstep3.jpg)

    I attached image of each step.
    Attached Files

  • #2
    Solved: Timepicker not match to MySQL

    OK, the problem solved.

    Just set 'Values format' -> 'Internal Format' to 'hhmm', too.

    as the images I attached.
    Attached Files

    Comment

    Working...
    X