Unable to cast value to be String for time(7) column

Unable to cast value to be String for time(7) column

sarooptrivedisarooptrivedi Posts: 45Questions: 15Answers: 2

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

  • sarooptrivedisarooptrivedi Posts: 45Questions: 15Answers: 2

    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.

Sign In or Register to comment.