Unable to cast value to be String for time(7) column
Unable to cast value to be String for time(7) column
![sarooptrivedi](https://secure.gravatar.com/avatar/cc7e56d1e7d3d7ea5ac4816c681bab5b/?default=https%3A%2F%2Fvanillicon.com%2Fcc7e56d1e7d3d7ea5ac4816c681bab5b_200.png&rating=g&size=120)
I get this error while reading data through view in editor.
How to manage Time(7) in Editor.
please check my code below.
var response = new Editor(db, "ItemTble", pkey)
.ReadTable("V_Items")
.Field(new Field("AId"))
.Field(new Field("ItemName"))
.Field(new Field("DateOn"))
.Field(new Field("TimeOn").SetFormatter(Format.DateSqlToFormat("HH:mm:ss")))
.Process(Request)
.Data();
Answers
Hello Team,
I figure out with DateTime format.
.Field(new Field("TimeOn").GetFormatter(Format.DateTime("HH:mm:ss")).SetFormatter(Format.DateTime("HH:mm:ss")))
Thank you.