<div dir="ltr"><br><br><div class="gmail_quote">On Fri, Feb 5, 2010 at 10:55 AM, Johannes Waldmann <span dir="ltr"><<a href="mailto:waldmann@imn.htwk-leipzig.de">waldmann@imn.htwk-leipzig.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">> and then read with my own parse string:"%Y-%m-%d %T%Q"<br>
> This seems to work just fine.<br>
<br>
</div>Thanks. - When I'm using that format string, I get:<br>
<br>
Convertible: error converting source data SqlLocalTime 2008-10-29 00:00:00<br>
of type SqlValue to type Data.Time.LocalTime.LocalTime.ZonedTime:<br>
incompatible types<br>
<br>
I guess I need to find out who wants ZonedTime.<br>
<br>
In my DB description (generated by dbdirect),<br>
the only time-related type is CalendarTime.<br>
<font color="#888888"><br>
J.<br>
</font><div><div></div><div class="h5"><br>
<br></div></div></blockquote><div>Did you append an empty string in the SELECT statement? If you append the empty string (||''), HDBC treats the field as text and so returns a SqlByteString. However, if you do not append the empty string, it treats the field as a timestamp and tries to convert it before it even reaches your code.<br>
<br>All of this is just speculation, of course, since I haven't actually looked at the code. But my "extensive" (ie, 5 minute) testing implies it to be true.<br><br>Michael <br></div></div></div>