Fwd: [sqlite-forum] Convert datetime string to second since Epoch with millisecond precision
Dominique Devienne <[email protected]> Tue, 17 Mar 2020 17:36:58 +0100
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAFCRh-_WFPmJnSdg-EEVqM+=eC_7LgtEyfHknd43J=-GeePdrw@mail.gmail.com> |
UmVwb3N0aW5nIHRvIHRoZSBNTCwgbWF5YmUgSSdsbCBoYXZlIG1vcmUgbHVjayB0aGVyZSwgdGhh biBpbiB0aGUgZm9ydW0/Ci0tREQKCi0tLS0tLS0tLS0gRm9yd2FyZGVkIG1lc3NhZ2UgLS0tLS0t LS0tCkZyb206IGRkZXZpZW5uZSA8bm9yZXBseTllYzc5ZTM1ZkBzcWxpdGUub3JnPgpEYXRlOiBU dWUsIE1hciAxNywgMjAyMCBhdCA1OjA5IFBNClN1YmplY3Q6IFtzcWxpdGUtZm9ydW1dIENvbnZl cnQgZGF0ZXRpbWUgc3RyaW5nIHRvIHNlY29uZCBzaW5jZSBFcG9jaCB3aXRoCm1pbGxpc2Vjb25k IHByZWNpc2lvbgpUbzogPGRkZXZpZW5uZUBnbWFpbC5jb20+CgoKRm9ydW0gcG9zdCBieSBkZGV2 aWVubmUgb24gMjAyMC0wMy0xNyAxNjowOToxNwpodHRwczovL3NxbGl0ZS5vcmcvZm9ydW0vZm9y dW1wb3N0LzBkOWMzMzhmZjEKCkhpLiBCZWxvdyBkb2VzIHdoYXQgSSB3YW50LCBidXQgc3VyZWx5 IHRoZXJlJ3MgYSBiZXR0ZXIgd2F5IHRoYW4gcGFyc2luZwp0aGUgZGF0ZXRpbWUgMyB0aW1lcz8g QmVjYXVzZSB0aGUgYmVsb3cgaXMgdWdseSBhcyBoZWxsLiBUaGFua3MsIC0tREQKCmBgYApDOlxV c2Vyc1xkZGV2aWVubmU+c3FsaXRlMwpTUUxpdGUgdmVyc2lvbiAzLjI4LjAgMjAxOS0wNC0xNiAx OTo0OTo1MwpFbnRlciAiLmhlbHAiIGZvciB1c2FnZSBoaW50cy4KQ29ubmVjdGVkIHRvIGEgdHJh bnNpZW50IGluLW1lbW9yeSBkYXRhYmFzZS4KVXNlICIub3BlbiBGSUxFTkFNRSIgdG8gcmVvcGVu IG9uIGEgcGVyc2lzdGVudCBkYXRhYmFzZS4Kc3FsaXRlPiBzZWxlY3QKICAgLi4uPiAgICAgICAg Y2FzdChzdHJmdGltZSgnJXMnLCAnMjAxNi0wNi0xM1QwOTozNjozNC4xMjNaJykgYXMgcmVhbCkg KwogICAuLi4+ICAgICAgICAgICAgIHN0cmZ0aW1lKCclZicsICcyMDE2LTA2LTEzVDA5OjM2OjM0 LjEyM1onKSAtCiAgIC4uLj4gICAgICAgIGNhc3Qoc3RyZnRpbWUoJyVTJywgJzIwMTYtMDYtMTNU MDk6MzY6MzQuMTIzWicpIGFzIHJlYWwpCiAgIC4uLj4gOwoxNDY1ODEwNTk0LjEyMwpzcWxpdGU+ CmBgYAotLSAKU3Vic2NyaXB0aW9uIGluZm86Cmh0dHBzOi8vc3FsaXRlLm9yZy9mb3J1bS9hbGVy dHMvNTRGNkRENDIwQjMxRkE3RjlGNjlGNTQ5OEYxNjMxRjVFNkQ0QjQ4Q0Y5NzUzOUZERUVGOTBG NzE3MzNFOTBBOQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f XwpzcWxpdGUtdXNlcnMgbWFpbGluZyBsaXN0CnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3Fs aXRlLm9yZwpodHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xp c3RpbmZvL3NxbGl0ZS11c2Vycwo=