Timepicker not match to MySQL

[itsarapong]

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.

[itsarapong]

Solved: Timepicker not match to MySQL

OK, the problem solved.

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

as the images I attached.