cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Syntax to query DateTime fields?

SOLVED
Highlighted
Regular Member

Syntax to query DateTime fields?

I'm trying to query a DateTime field in a DataTable.  A filter like

{ "filters": { "type": "GT", "fieldName": "endTime", "value": "2017-01-30 00:00:00" } }

does not seem to work.  What is the syntax to find all rows after a certain date?

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Syntax to query DateTime fields?

Figured it out.  It looks like the query value is a timestamp in milliseconds.

View solution in original post

2 REPLIES 2
Highlighted

Re: Syntax to query DateTime fields?

Figured it out.  It looks like the query value is a timestamp in milliseconds.

View solution in original post

Highlighted

Re: Syntax to query DateTime fields?

Hi Chris,

Yes, from the back-end side the DateTime property is stored in the form of milliseconds. Not only for query purposes.

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!