ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 3 replies, has 3 voices, and was last updated by ypetrov ypetrov 1 month, 3 weeks ago.

  • Creator
    Topic
  • #35527
    golriz.nourani
    golriz.nourani
    Participant

    Dears

    I used time format of oro in datagrid but for all times more than 838:58:58 , data is 838:58:58
    could you help me?
    Thanks
    Golriz

Viewing 3 replies - 1 through 3 (of 3 total)
  • Author
    Replies
  • #35530
    msulima
    msulima
    Oro Core

    Hi, golriz.nourani.
    Please, provide an example of data using. What type of datagrid field you use?

    #35540
    golriz.nourani
    golriz.nourani
    Participant

    Hi,msulima
    my code is below

    select:
    -TIMEDIFF(max(v.outTime),min(v.inTime) )) as totalduration
    .
    .
    .
    columns:
    totalduration:
    label: orocrm.visit.total_durattion
    frontend_type: time

    #35550
    ypetrov
    ypetrov
    Participant

    Hello golriz.nourani.
    As far doctrine don’t have much functions to works with dates, I would advice such solution:
    1)

    2)

    3)

    I leave {{ dump() }} just to show that result will be \DateInterval so you should decide what to do next, hope approach is clear.

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.