How can I make usage of an time(7) field from an MSSQL database

LairdTurner

The only field Datatables know are datetime fields but how about time fields with a format of '22:10:00.0000000'.
How can I make use of them espacially validate them etc.

allan

Ideally you would reformat them on the server into the format that the client expects, so the client-side never sees the database format. The server should also to the validatoin and deformatting back into the db format.

However, you could potentially use dt-init column.render` to do the reformatting on the client-side.

Regards,
Allan