kind of surprised this isn’t in the forums, which probably means i am missing something obvious. when i
MATCH (rf:Finding)-->(rv:Rapid7IVMVulnerability),
(rf)-->(ra:Rapid7IVMAsset)
and i match rv.datePublished is returned as epoch date(1438732800 seconds). i need convert this to a date mm/dd/yyyy. i’ve tried date() but it returns like Dec 31, 1, 1:07PM. interestingly when i use a minimal query
MATCH (r:Rapid7IVMVulnerability)
WHERE r.riskScoreV2_0 > 700
RETURN
r.id AS vuln_ID,
r.title AS vuln_title,
r.datePublished AS datePublished,
r.dateModified AS dateModified,
r.dateAdded AS dateAdded
LIMIT 50
it returns as a date 1993-06-15T00:00:00+00:00
tells me i am missing something obvious. Anyone have an idea to convert the date?