continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wendy Smoak" <wsm...@gmail.com>
Subject Querying the builds database on date ranges
Date Mon, 29 Sep 2008 20:26:23 GMT
Any suggestions on directly querying the Continuum builds database on
a date range?

We're using MySQL, and the "time" fields are stored as bigint.
(BUILDRESULT.START_TIME and END_TIME I think.)

I'd like to get totals by build result state for last week.  The usual
" ... < '2008-09-26'" doesn't work with these fields.  I'm guessing
this is an internal Java date/time format... what is it, and what's
the easiest way to work with it?

Thanks,
-- 
Wendy

Mime
View raw message