怎么用上面这个函数解析出这个字符串[ { "departureTime":"1651489200", "placeType":"address", "originalLocation":{ "lng":-73.0014878, "lat":41.3975181 }, "waypointType":"departure", "location":{ "lng":-73.00162, "lat":41.39766 }, "dwellTime":0, "objectType":"waypoint", "addressName":"", "stopId":-1, "loadStopType":"load_start_point" } ]并找到departureTime的值
时间: 2023-05-18 10:03:55 浏览: 38
可以使用 JSON.parse() 函数将字符串解析为 JSON 对象,然后通过对象的属性名获取 departureTime 的值。具体代码如下:
```
const str = '[{"departureTime":"1651489200","placeType":"address","originalLocation":{"lng":-73.0014878,"lat":41.3975181},"waypointType":"departure","location":{"lng":-73.00162,"lat":41.39766},"dwellTime":0,"objectType":"waypoint","addressName":"","stopId":-1,"loadStopType":"load_start_point"}]';
const obj = JSON.parse(str);
const departureTime = obj[0].departureTime;
console.log(departureTime);
```
输出结果为:1651489200
相关问题
怎么用sql的json_extract_scalar函数解析出这个字符串[ { "departureTime":"1651489200", "placeType":"address", "originalLocation":{ "lng":-73.0014878, "lat":41.3975181 }, "waypointType":"departure", "location":{ "lng":-73.00162, "lat":41.39766 }, "dwellTime":0, "objectType":"waypoint", "addressName":"", "stopId":-1, "loadStopType":"load_start_point" } ]并找到departureTime的值
可以使用以下SQL语句来解析出departureTime的值:
SELECT JSON_EXTRACT_SCALAR(json_string, '$[0].departureTime') AS departureTime FROM table_name;
其中,json_string是包含上述JSON字符串的列名,table_name是包含该列的表名。执行该SQL语句后,将返回departureTime的值。
qt 解析 'Wed, 19 Apr 2023 09:54:05 GMT' 这个时间字符串
应该使用 QDateTime::fromString() 函数来解析这个时间字符串,具体代码如下:
QDateTime datetime = QDateTime::fromString("Wed, 19 Apr 2023 09:54:05 GMT", "ddd, dd MMM yyyy hh:mm:ss 'GMT'");
其中第一个参数是要解析的时间字符串,第二个参数是时间字符串的格式化字符串。