topic SQL timestamp format. in ArcGIS Web AppBuilder Questions

SQL timestamp format.

ChetShuler — Wed, 20 Jan 2016 17:30:22 GMT

My IT department extracts crime data with a timestamp field. When I setup my query only the data appears in pick list.. Is the problem in the data extract format from SQL. Or the Web App Builder does not support a timestamp field? Some extract the timestamp does not appear at all. Works fine within ArcMap.

Re: SQL timestamp format.

RobertScheitlin__GISP — Wed, 20 Jan 2016 17:35:07 GMT

Chet,

Your question does not make a lot of sense to me. But to answer the last part of your question Yes WAB does support timestamp/date fields.

Re: SQL timestamp format.

ChetShuler — Wed, 20 Jan 2016 17:40:09 GMT

Do you know of any reason why the timestamp field would only produce a date with no time? Or why some of the extracts the timestamp field does not appear in WAB?

Chet Shuler, P.S. | Chief Engineering Technician / GIS

City of Middletown — Information Systems

1 Donham Plaza

Middletown, Ohio 45042-1932

(513) 425-7920 Office

(513) 425-7921 Fax

<https://www.facebook.com/cityofmiddletownoh> <http://www.twitter.com/CityMiddletown> <https://www.linkedin.com/company/city-of-middletown> <https://instagram.com/cityofmiddletownohio>

Re: SQL timestamp format.

ChetShuler — Wed, 20 Jan 2016 17:51:00 GMT

Do you know of any reason why the timestamp field would only produces a date with no time in the query builder? Or why some of the extracts the timestamp field does not appear at all in WAB? I'm thinking it may be the way they are extracting the data from a older database. They tried to create a view within SQL and separate the date and time. However the our police department wants to be able to query the timestamp field between for an example between 1/1/2016 22:00:00 hours and 1/2/2016 02:00:00 hours the next day. Has to be a format issues.

Sorry I had some typos in the previous post.. Wasn't expecting a quick reply.. Thanks..

Re: SQL timestamp format.

RobertScheitlin__GISP — Wed, 20 Jan 2016 17:59:45 GMT

Chet,

The query widget does not support querying by a specific time from the UI. The code behind the scenes sets the time portion of the chosen date to cover the 24 hour period of that date. If you want to query a specific time of a specific date then that would involve customizing the widgets UI and code base to support that.