issue_comments: 1239699276

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/484#issuecomment-1239699276 https://api.github.com/repos/simonw/sqlite-utils/issues/484 1239699276 IC_kwDOCGYnMM5J5E9M 9599 2022-09-07T17:49:49Z 2022-09-07T17:49:49Z OWNER

This feature is a tiny bit weird though: the recipe functions are not exposed to SQL by default, they are instead designed to be used with sqlite-utils convert. I guess with --functions support you could do something like this:

sqlite-utils data.db "update mytable set col1 = parsedate(col1)" --functions "parsedate = r.parsedate"

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1363766973