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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Syntax to query DateTime fields?

chmaloof
7-Bedrock

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

2 REPLIES 2

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

jkaczynski
4-Participant
(To:chmaloof)

Hi Chris,

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

Top Tags