Re: CLSQL Wall-Time - Timestamptz vs Timestamp issues
james anderson <[email protected]> Wed, 7 Feb 2018 16:09:22 +0000
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <0102016171075947-5d7101a4-5d79-4ef4-a4e2-14674c7c8eb1-000000@eu-west-1.amazonses.com> |
Z29vZCBhZnRlcm5vb24KCj4gT24gMjAxOC0wMi0wNywgYXQgMTU6NDcsIFJ1c3MgVHluZGFsbCA8 cnVzc0BhY2NlbGVyYXRpb24ubmV0PiB3cm90ZToKPiAKPiBJIGZlZWwgbGlrZSB5b3VyIHF1ZXN0 aW9uIGlzIGRpc2luZ2VudW91cywKCm9uIHRoZSBjb250cmFyeS4KaXQgY29tZXMgZnJvbSBzZXZl cmFsIGRlY2FkZXMgb2YgcnVubmluZyBzZXJ2ZXJzIHdoaWNoIGNvbXByaXNlIHRlbXBvcmFsIG1v ZGVscy4KCj4gYW5kIGltcGxpZXMgd2UgYXJlIG5vdCBhbGwKPiBtaXJlZCBieSB5ZWFycyBvZiBw YXN0IHBvb3IgZGVjaXNpb25zIGFuZCBhcHBsaWNhdGlvbnMgd2UgZG9udAo+IGNvbnRyb2wuIFNv bWUgcGVvcGxlICpkbyogZ2xlZWZ1bGx5IHN0b3JlIHdoYXRldmVyIHRoZXkgd2FudCB3aGVyZQo+ IGV2ZXIgdGhleSB3YW50LiBUaGlzIGluY2x1ZGVzIG51bWJlcnMgaW4gdGV4dCBmaWVsZHMsIGRh dGVzIHdpdGhvdXQKPiB0aW1lem9uZXMsIGFuZCBiYXNpY2FsbHkgYW55IG90aGVyIGJhZCBkZXNp Z24geW91IGNhbiBpbWFnaW5lLiBBcyBhCj4gY29uc3VsdGFudCwgSSBoYXZlIGhhZCB0byBkZWFs IHdpdGggZXZlcnkgcG9zc2libGUgYmFkIGRlc2lnbgo+IGRlY2lzaW9uLCBhbmQgSSBzdGlsbCBu ZWVkIHRvIGludGVyZmFjZSB3aXRoIGl0IGFuZCBub3QgY2F1c2UgYnVncy4gSQo+IGRvbid0IGJl bGlldmUgdGhhdCBpdCBpcyB0aGUgZGF0YWJhc2UgaW50ZXJmYWNlIGxheWVycyBqb2IgdG8gYmUK PiBwb2xpdGljYWwgYWJvdXQgd2hhdCBmZWF0dXJlcyBvZiB0aGUgYmFja2VuZCBpdCBzdXBwb3J0 cyBvciB3aGljaAo+IGFwcGxpY2F0aW9ucyBzaG91bGQgYmUgYWJsZSB0byBtYWtlIHVzZSBvZiBp dC4KPiAKPiBBZGRpdGlvbmFsbHkgSSBoYXZlIHByb2JsZW1zIHdpdGggdGhpcyBwYXJ0aWN1bGFy bHkgYXMgbm8gdXNlciBlbnRlcnMKPiBkYXRlcyBhbmQgdGltZXMgd2l0aCBhIHRpbWV6b25lIC0g bWVhbmluZyBJICptdXN0KiBhY2NlcHQgdGhhdCBzb21lCj4gZGF0ZXMgYXJlIGxvY2FsIGFuZCBz b21lIGFyZSBVVEMgYW5kIGl0IG1ha2VzIGl0IG11Y2ggZWFzaWVyIHRvCj4gb3BlcmF0ZSB3aXRo IGlmIHRoaXMgaXMgdHJhY2tlZC4KCmFzIHlvdSB3aXNoLgoKPiAKPiBDaGVlcnMsCj4gUnVzcyBU eW5kYWxsCj4gQWNjZWxlcmF0aW9uLm5ldAo+IAo+IAo+IAo+IC0tLS0tIE9yaWdpbmFsIE1lc3Nh Z2UgLS0tLS0KPiBGcm9tOiBqYW1lcyBhbmRlcnNvbiBbbWFpbHRvOmphbWVzQGR5ZHJhLmNvbV0K PiBUbzogY2xzcWxAYm9hLmtwZS5pbwo+IFNlbnQ6IFdlZCwgNyBGZWIgMjAxOCAwODoxMTo1MSAr MDAwMAo+IFN1YmplY3Q6IFJlOiBbQ0xTUUxdIENMU1FMIFdhbGwtVGltZSAtIFRpbWVzdGFtcHR6 IHZzIFRpbWVzdGFtcCBpc3N1ZXMKPiAKPiBnb29kIG1vcm5pbmc7Cj4gCj4+IE9uIDIwMTgtMDIt MDcsIGF0IDAyOjQwLCBSdXNzIFR5bmRhbGwgPHJ1c3NAYWNjZWxlcmF0aW9uLm5ldD4gd3JvdGU6 Cj4+IAo+Pj4gV2l0aG91dCB0aGlzIGNoYW5nZSwgYHRpbWVzdGFtcHR6YHMgYXJlIHJlYWQgYXMg bG9jYWx0aW1lcyBhbmQgc2F2ZWQgYXMgCj4+PiBsb2NhbHRpbWVzLCB3aGVuIHRoZXkgc2hvdWxk IGJlIHJlYWQgYW5kIHByaW50ZWQgYXMgVVRDIHRpbWVzIC0gd2hpY2ggbGVhZHMKPj4+IHRvIHRo b3NlIGZpZWxkcyBjdXJzb3JpbmcgKGluY3JlbWVudGluZyBieSBvZmZzZXQpIGJlY2F1c2UgdGhl eSBhcmUgY29udGludW91c2x5Cj4+PiByZWNvbnZlcnRlZCB0byBVVEMgZnJvbSBsb2NhbHRpbWVz Lgo+PiAKPj4gVGhlIHRpbWVzdGFtcCBkYXRhIHR5cGUgaXMgYSB6b25lbGVzcyB0aW1lIChsZWZ0 IHRvIHRoZSBhcHBsaWNhdGlvbiB0byBkZXRlcm1pbmUgaWYgaXRzIFVUQyAKPj4gb3IgbG9jYWwg dGltZSBvciB3aGF0ZXZlciksIHRoZSB0aW1lc3RhbXB0eiBkYXRhdHlwZSBpcyBhIFVUQyB0aW1l LiBJZiB3ZSBkb24ndCB0cmFjayB0aGF0IAo+PiBzb21lIG9mIHRoZSB0aW1lcyBhcmUgem9ubGVz cy9sb2NhbCBhbmQgc29tZSBhcmUgVVRDLCB0aGVuIGl0IGJlY29tZXMgaW1wb3NzaWJsZSB0byB0 ZWxsCj4+IHdoZW4gb25lIHNob3VsZCBjb252ZXJ0IHRvIGEgVVRDIGFuZCB3aGVuIG9uZSBzaG91 bGRuJ3QgKGdlbmVyYWxseSBsZWFkaW5nIHRvIGJ1Z3MgCj4+IHJlbGF0aW5nIHRvIGNvbnZlcnRp bmcgbm90IGVub3VnaCBvciB0b28gbWFueSB0aW1lcykuIFpvbmVsZXNzIHRpbWVzIGFyZSBpbiB0 aGUgU1FMLTkyIAo+PiBhbmQgYmV5b25kIHN0YW5kYXJkIGZvciB0aGUgZGF0YXR5cGUgInRpbWVz dGFtcCIsIHNvIEkgYmVsaWV2ZSB0byBjb3JyZWN0bHkgYWNjb3VudCBmb3IgdGhlCj4+IHR3byBk aWZmZXJlbnQgZGF0YXR5cGVzICh6b25lbGVzcyB2cyBVVEMpIGFuZCBjb3JyZWN0bHkgcHJpbnQg YW5kIHJlYWQgdGhvc2UgdmFsdWVzLCBJIGhhdmUKPj4gdG8gdHJhY2sgbWluaW1hbGx5IGEgc2lu Z2xlIGJpdCBkaWZmZXJlbnRpYXRpbmcgdGhlIHR3by4KPiAKPiBpIHVuZGVyc3RhbmQgeW91ciB0 ZXh0LCBhYm92ZSwgYnV0LCBpIHJlaXRlcmF0ZSBteSBxdWVzdGlvbjogd2h5IHdvdWxkIG9uZSBl dmVyIHB1dCBhIG5vbi11dGMgdGltZSBpbiBhIHByb2R1Y3Rpb24gZGF0YWJhc2U/Cj4gCj4gCj4g Cj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBDTFNR TCBtYWlsaW5nIGxpc3QKPiBDTFNRTEBsaXN0cy5rcGUuaW8KPiBodHRwOi8vbGlzdHMua3BlLmlv L2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9jbHNxbAo+IAo+IF9fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gQ0xTUUwgbWFpbGluZyBsaXN0Cj4gQ0xTUUxA bGlzdHMua3BlLmlvCj4gaHR0cDovL2xpc3RzLmtwZS5pby9jZ2ktYmluL21haWxtYW4vbGlzdGlu Zm8vY2xzcWwKCi0tLQpqYW1lcyBhbmRlcnNvbiB8IGphbWVzQGR5ZHJhLmNvbSB8IGh0dHA6Ly9k eWRyYS5jb20KCgoKCgoKX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX18KQ0xTUUwgbWFpbGluZyBsaXN0CkNMU1FMQGxpc3RzLmtwZS5pbwpodHRwOi8vbGlzdHMu a3BlLmlvL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9jbHNxbAo=