1. 

   Fredrik Terent, Member

   Hi,
   I have a problem with a summary of an time field.

   The query returns a field as CAST(IFNULL(Pho.tid,0) as time) as '#{Talk_time}[Samtalstid]'
   I specify the column style with SELECT 'dbr.colstyle', '[Samtalstid]', 'hh:mm:ss';

   The cross tabulation is done by date and as long as I only chooses 1 day, the hsum are presented in a time format, but as soon as I have 2 or more days, then te hsum only shows an integer...

   What am I doing wrong?

   Regards Fredrik
2. 

   myDBR Team, Key Master

   Fredrik,
   The hsum does not yet support time datatype for calculation, but if you leave out the time conversion (cast) and just select seconds, the 'hh:mm:ss'-colstyle will take care of the conversion and will show you the seconds formatted as time.

   --
   myDBR Team
3. 

   Fredrik Terent, Member

   Thanks, it works in the

   normal

   columns, but still not in the hsum. Do I need to specify the columnstyle in any way for the hsum?
4. 

   myDBR Team, Key Master

   Fredrik,
   make sure you are running the latest build.

   --
   myDBR Team
5. 

   Fredrik Terent, Member

   It works (I had a SECS_TO_TIME) in a temporary table, that caused me the problem.

   Thanks for good support!

Reply

You must log in to post.