Re: Fwd: [sqlite-forum] Convert datetime string to second since Epoch with millisecond precision
"Keith Medcalf" <[email protected]> Tue, 17 Mar 2020 11:07:40 -0600
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Organization | This Side Up |
| Message-ID | <[email protected]> |
CnNlbGVjdCAoc3RyZnRpbWUoJyVKJywgJzIwMTYtMDYtMTNUMDk6MzY6MzQuMTIzWicpIC0gMjQ0 MDU4Ny41KSAqIDg2NDAwLjA7CjE0NjU4MTA1OTQuMTIzCgotLSAKVGhlIGZhY3QgdGhhdCB0aGVy ZSdzIGEgSGlnaHdheSB0byBIZWxsIGJ1dCBvbmx5IGEgU3RhaXJ3YXkgdG8gSGVhdmVuIHNheXMg YSBsb3QgYWJvdXQgYW50aWNpcGF0ZWQgdHJhZmZpYyB2b2x1bWUuCgo+LS0tLS1PcmlnaW5hbCBN ZXNzYWdlLS0tLS0KPkZyb206IHNxbGl0ZS11c2VycyA8c3FsaXRlLXVzZXJzLWJvdW5jZXNAbWFp bGluZ2xpc3RzLnNxbGl0ZS5vcmc+IE9uCj5CZWhhbGYgT2YgRG9taW5pcXVlIERldmllbm5lCj5T ZW50OiBUdWVzZGF5LCAxNyBNYXJjaCwgMjAyMCAxMDozNwo+VG86IEdlbmVyYWwgRGlzY3Vzc2lv biBvZiBTUUxpdGUgRGF0YWJhc2UgPHNxbGl0ZS0KPnVzZXJzQG1haWxpbmdsaXN0cy5zcWxpdGUu b3JnPgo+U3ViamVjdDogW3NxbGl0ZV0gRndkOiBbc3FsaXRlLWZvcnVtXSBDb252ZXJ0IGRhdGV0 aW1lIHN0cmluZyB0byBzZWNvbmQKPnNpbmNlIEVwb2NoIHdpdGggbWlsbGlzZWNvbmQgcHJlY2lz aW9uCj4KPlJlcG9zdGluZyB0byB0aGUgTUwsIG1heWJlIEknbGwgaGF2ZSBtb3JlIGx1Y2sgdGhl cmUsIHRoYW4gaW4gdGhlIGZvcnVtPwo+LS1ERAo+Cj4tLS0tLS0tLS0tIEZvcndhcmRlZCBtZXNz YWdlIC0tLS0tLS0tLQo+RnJvbTogZGRldmllbm5lIDxub3JlcGx5OWVjNzllMzVmQHNxbGl0ZS5v cmc+Cj5EYXRlOiBUdWUsIE1hciAxNywgMjAyMCBhdCA1OjA5IFBNCj5TdWJqZWN0OiBbc3FsaXRl LWZvcnVtXSBDb252ZXJ0IGRhdGV0aW1lIHN0cmluZyB0byBzZWNvbmQgc2luY2UgRXBvY2gKPndp dGgKPm1pbGxpc2Vjb25kIHByZWNpc2lvbgo+VG86IDxkZGV2aWVubmVAZ21haWwuY29tPgo+Cj4K PkZvcnVtIHBvc3QgYnkgZGRldmllbm5lIG9uIDIwMjAtMDMtMTcgMTY6MDk6MTcKPmh0dHBzOi8v c3FsaXRlLm9yZy9mb3J1bS9mb3J1bXBvc3QvMGQ5YzMzOGZmMQo+Cj5IaS4gQmVsb3cgZG9lcyB3 aGF0IEkgd2FudCwgYnV0IHN1cmVseSB0aGVyZSdzIGEgYmV0dGVyIHdheSB0aGFuIHBhcnNpbmcK PnRoZSBkYXRldGltZSAzIHRpbWVzPyBCZWNhdXNlIHRoZSBiZWxvdyBpcyB1Z2x5IGFzIGhlbGwu IFRoYW5rcywgLS1ERAo+Cj5gYGAKPkM6XFVzZXJzXGRkZXZpZW5uZT5zcWxpdGUzCj5TUUxpdGUg dmVyc2lvbiAzLjI4LjAgMjAxOS0wNC0xNiAxOTo0OTo1Mwo+RW50ZXIgIi5oZWxwIiBmb3IgdXNh Z2UgaGludHMuCj5Db25uZWN0ZWQgdG8gYSB0cmFuc2llbnQgaW4tbWVtb3J5IGRhdGFiYXNlLgo+ VXNlICIub3BlbiBGSUxFTkFNRSIgdG8gcmVvcGVuIG9uIGEgcGVyc2lzdGVudCBkYXRhYmFzZS4K PnNxbGl0ZT4gc2VsZWN0Cj4gICAuLi4+ICAgICAgICBjYXN0KHN0cmZ0aW1lKCclcycsICcyMDE2 LTA2LTEzVDA5OjM2OjM0LjEyM1onKSBhcyByZWFsKSArCj4gICAuLi4+ICAgICAgICAgICAgIHN0 cmZ0aW1lKCclZicsICcyMDE2LTA2LTEzVDA5OjM2OjM0LjEyM1onKSAtCj4gICAuLi4+ICAgICAg ICBjYXN0KHN0cmZ0aW1lKCclUycsICcyMDE2LTA2LTEzVDA5OjM2OjM0LjEyM1onKSBhcyByZWFs KQo+ICAgLi4uPiA7Cj4xNDY1ODEwNTk0LjEyMwo+c3FsaXRlPgo+YGBgCj4tLQo+U3Vic2NyaXB0 aW9uIGluZm86Cj5odHRwczovL3NxbGl0ZS5vcmcvZm9ydW0vYWxlcnRzLzU0RjZERDQyMEIzMUZB N0Y5RjY5RjU0OThGMTYzMUY1RTZENEI0OENGCj45NzUzOUZERUVGOTBGNzE3MzNFOTBBOQo+X19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPnNxbGl0ZS11c2Vy cyBtYWlsaW5nIGxpc3QKPnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwo+aHR0 cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxp dGUtdXNlcnMKCgoKX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxpdGUtdXNlcnNAbWFpbGluZ2xpc3RzLnNx bGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2NnaS1iaW4vbWFpbG1hbi9s aXN0aW5mby9zcWxpdGUtdXNlcnMK