sysnajar/gist:62e3679914c606d843ffb1108287d385

Created May 26, 2018 03:05

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sysnajar/62e3679914c606d843ffb1108287d385.js"></script>
Save sysnajar/62e3679914c606d843ffb1108287d385 to your computer and use it in GitHub Desktop.

Download ZIP

jq generate Date field from string fields (createDate and createTime)

Raw

gistfile1.txt

./list_dopa.lua | jq -c '.data []| {date: (.createDate + .createTime[0:5]) | strptime("%m/%d/%y%H:%M") | mktime , date2: (.createDate + .createTime[0:5]) | strptime("%m/%d/%y%H:%M") | todate, createDate: .createDate, createTime :.createTime, id : ._id}'  

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment