Conversion for SqlIntervalT in makeSqlValue doesn't handle intervals with days #9

nomeata opened this Issue Jun 19, 2011 · 0 comments

1 participant


Josh reports at against version

When HDBC-postgresql converts a SqlIntervalT to a SqlDiffTime in
makeSqlValue, it assumes hours:minutes:seconds, splits on ':', and tries
to use "read" to parse two Integer values and a Double. However,
postgresql stores intervals internally as months, days, and seconds; the
separate days field allows for 23-hour or 25-hour days (thank you
daylight savings time). For such intervals, postgresql outputs "N mons
N days N:N:N.N", with any of the three components omitted if zero. This
causes HDBC-postgresql to fail in "read".

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment