How to display time field in hh:mm:ss format

gmandelli · Post by **gmandelli** » Sat Nov 18, 2023 11:47 pm

The table on the mysql database has a time field.

I would like to present the format ih hour, minute and seconds (hh:mm:ss).

How is this possible?

Regards,
John

MichaelG · Post by **MichaelG** » Sun Nov 19, 2023 10:38 pm

You can use the Row_Rendered server event to format the field. For example:

Field.ViewValue = Convert.ToDateTime(Field.CurrentValue).ToString("HH:mm:ss");

gmandelli · Post by **gmandelli** » Thu Nov 23, 2023 2:49 pm

Ok.

But on insert field the control for time accept only hh:mm and not hh:mm:ss.

How to let user to insert HH.mm:ss in this Time datatype field?

Regards,,
John