Timepicker format issue

Applications Forms
#1

I’m trying to add a timepicker hhmm format to my db, it saves it as expected however it’s saving it as 00:hh:mm not hh:mm:ss I’ve set the Internal Format to hhii and HHII and HHIISS and HHMM, hhmm and any other format but it refuses to save it in the database correctly.

My db is set to time which saves it as hh:mm:ss am I missing something here?

#2

Have also noticed SQL Type = INT when its set as TIME, no matter what I do it wont change… even setting as say VARCHAR it stays as int???

#3

Thanks to support I fixed the issue, turns out it was a event I had setup malformed the time coding…