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

ASP.NET Maker General Discussion (ASP.NET Maker)
1

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

2

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

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

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