[Dbix-class] Re: Insert in MSSQL fails on date time fields

Rob Kinyon rob.kinyon at gmail.com
Tue Sep 24 11:01:37 GMT 2013


VGhpcyBpcyBnb2luZyB0byBzb3VuZCBzdHVwaWQsIGJ1dCBoYXZlIHlvdSB0cmllZCAkci0+e3Nv
bWVkYXRlfSA9CiInJHItPntzb21lZGF0ZX0nIj8KCklmIHRoYXQgZG9lc24ndCB3b3JrLCB0aGVy
ZSBhcmUgbW9yZSBpZGVhcywgYnV0IGxldCdzIHRyeSB0aGUgc2ltcGxlc3QKdGhpbmdzIGZpcnN0
LgpPbiBTZXAgMjQsIDIwMTMgNjozMSBBTSwgIldpbGxpYW0gR29lZGlja2UiIDxiaWxseUBicmFu
dC1pbnRlcmFjdGl2ZS5jb20+Cndyb3RlOgoKPiBEZWFyIFknYWxsIC0KPgo+IERhbW4gaXQsIEkg
c2VudCBhIGJyb2tlbiB2ZXJzaW9uLiAgQXBvbG9naWVzLiAgVGhlIGZvbGxvd2luZyBzbmlwcGV0
Cj4gaW5jbHVkZXMgdGhlIG1pc3NpbmcgIndoaWxlIiBsaW5lLgo+Cj4gLi4uCj4gICAkc3RoID0g
JGRiaC0+cHJlcGFyZSgiU0VMRUNUICogRlJPTSAkdGFibGVfbmFtZSIpIHx8IGRpZSAkZGJoLT5l
cnJzdHI7Cj4gICAkc3RoLT5leGVjdXRlKCkgfHwgcHJpbnQgIiRzdGgtPmVycnN0clxuXG4iOwo+
Cj4gICB3aGlsZSggJHIgPSAkc3RoLT5mZXRjaHJvd19oYXNocmVmKSB7Cj4gICAgIG15ICRuZXdy
ZWMgPSAkc2NoZW1hLT5yZXN1bHRzZXQoJHRhYmxlX25hbWUpLT5jcmVhdGUoJHIpOwo+ICAgICAk
bmV3cmVjLT5pbl9zdG9yYWdlKCk7Cj4gICB9Cj4gICAkc3RoLT5maW5pc2g7Cj4gLi4uCj4KPiBP
biBTZXAgMjMsIDIwMTMsIGF0IDE6MTMgUE0sIFdpbGxpYW0gR29lZGlja2UgPGJpbGx5QGJyYW50
LWludGVyYWN0aXZlLmNvbT4KPiB3cm90ZToKPgo+IERlYXIgWSdhbGwgLQo+Cj4gSSdtIG1pZ3Jh
dGluZyBhIGJ1bmNoICgxMDBpc2gpIHRhYmxlcyBmcm9tIEZveHBybyAyLjYgdG8gTVNTUUwuCj4K
PiBUaGUgZm9sbG93aW5nIGNvZGUgd29ya3MgYWxtb3N0IHBlcmZlY3RseS4KPgo+IHVzZSBWQl9U
ZW1wOjpNYWluOwo+IHVzZSBEQkk7Cj4gdXNlIERhdGE6OkR1bXBlcjsKPgo+IG15ICRzY2hlbWEg
PSBWQl9UZW1wOjpNYWluLT5jb25uZWN0KCdkYmk6T0RCQzpWQl9UZW1wJyk7Cj4KPiBteSAkZGJm
X2RpciA9ICdDOi91c2Vycy9nb2VkaWN3L2RvY3VtZW50cy92b2ljZWJhc2Uvdm9pY2VkYi8nOwo+
IG15ICRkYmggPSBEQkktPmNvbm5lY3QoIkRCSTpYQmFzZToiLiRkYmZfZGlyKSBvciBkaWUgJERC
STo6ZXJyc3RyOwo+Cj4gZm9yZWFjaCAoIGtleXMgJHNjaGVtYS0+eydjbGFzc19tYXBwaW5ncyd9
KSB7Cj4gICAvOjooW146XSspJC87Cj4gICBteSAkdGFibGVfbmFtZSA9ICQxOwo+Cj4gICBteSAk
dmJfdGVtcF9ycyA9ICRzY2hlbWEtPnJlc3VsdHNldCgkdGFibGVfbmFtZSk7Cj4KPiAgICR2Yl90
ZW1wX3JzLT5kZWxldGVfYWxsOwo+Cj4gICAkc3RoID0gJGRiaC0+cHJlcGFyZSgiU0VMRUNUICog
RlJPTSAkdGFibGVfbmFtZSIpIHx8IGRpZSAkZGJoLT5lcnJzdHI7Cj4gICAkc3RoLT5leGVjdXRl
KCkgfHwgcHJpbnQgIiRzdGgtPmVycnN0clxuXG4iOwo+Cj4gICAgIG15ICRuZXdyZWMgPSAkc2No
ZW1hLT5yZXN1bHRzZXQoJHRhYmxlX25hbWUpLT5jcmVhdGUoJHIpOwo+ICAgICAkbmV3cmVjLT5p
bl9zdG9yYWdlKCk7Cj4gICB9Cj4gICAkc3RoLT5maW5pc2g7Cj4gfQo+Cj4gRXhjZXB0IGl0IGZh
aWxzIG9uIGRhdGV0aW1lIGZpZWxkcy4gIEkgc2VlIHRoYXQgdGhlIGluc2VydCBzdGF0ZW1lbnQg
aXMKPiBjb25zdHJ1Y3RlZCB0byBsb29rIGxpa2U6Cj4KPiBpbnNlcnQgaW50byB0YmwgKGtleSwg
c29tZWRhdGUpIHZhbHVlcygxMDAsIDE5OTMwMzEyKTsKPgo+IHdoaWNoIGZhaWxzLgo+Cj4gaW5z
ZXJ0IGludG8gdGJsIChrZXksIHNvbWVkYXRlKSB2YWx1ZXMoMTAwLCAnMTk5MzAzMTIzJykKPgo+
IGhvd2V2ZXIgd29ya3MgZmluZSwgYnV0IEkgY2FuJ3QgZ2V0IG15IHNjcmlwdCB0byBnZW5lcmF0
ZSB0aGUgZmllbGQgdmFsdWUKPiB0aGF0IHdheS4KPgo+IEFsbCBoZWxwIGlzLCBvZiBjb3Vyc2Us
IG1vc3QgYXBwcmVjaWF0ZWQuCj4KPiAgICAtIEJpbGx5Cj4KPgo+Cj4gX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBMaXN0OiBodHRwOi8vbGlzdHMuc2Nz
eXMuY28udWsvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL2RiaXgtY2xhc3MKPiBJUkM6IGlyYy5w
ZXJsLm9yZyNkYml4LWNsYXNzCj4gU1ZOOiBodHRwOi8vZGV2LmNhdGFseXN0LnBlcmwub3JnL3Jl
cG9zL2Jhc3QvREJJeC1DbGFzcy8KPiBTZWFyY2hhYmxlIEFyY2hpdmU6Cj4gaHR0cDovL3d3dy5n
cm9rYmFzZS5jb20vZ3JvdXAvZGJpeC1jbGFzc0BsaXN0cy5zY3N5cy5jby51awo+Ci0tLS0tLS0t
LS0tLS0tIG5leHQgcGFydCAtLS0tLS0tLS0tLS0tLQpBbiBIVE1MIGF0dGFjaG1lbnQgd2FzIHNj
cnViYmVkLi4uClVSTDogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL3BpcGVybWFpbC9kYml4LWNs
YXNzL2F0dGFjaG1lbnRzLzIwMTMwOTI0LzM1ZDM0M2E1L2F0dGFjaG1lbnQuaHRtCg==


More information about the DBIx-Class mailing list