Forum Discussion

arthur_'s avatar
arthur_
Guide
7 years ago

Get post_time through API v2

Hi,   We are trying to get date when post was created using query similar to one below:   SELECT conversation.last_post_time, current_revision.last_edit_time, post_time FROM messages WHERE board....
  • VikasB's avatar
    VikasB
    7 years ago

    arthur_

    It seems there is some misunderstanding or it may be your instance-specific issue. Every message will return there own post time.  See here https://prnt.sc/iq7b9r

    If you want to get the only main topic then you have to pass the depth but it does not mean by passing the depth it returns the right time.

    select id, depth,post_time from messages where depth = 0 order by post_time desc
arthur_'s avatar
arthur_
Guide

VikasB

 

Thank you for the prompt reply.

 

The problem is that post_date does not contain the time when post itself was created, but it returns the date of the last comment.

VikasB's avatar
VikasB
Boss
7 years ago

arthur_

FYI it would not return the post_time in your local time. It would return the Pacific time (server time). I posted the message and then posted a reply on it. It returns the right post time. 

See here https://prnt.sc/iq5gpz

 

  • arthur_'s avatar
    arthur_
    Guide
    7 years ago

    VikasB

     

     

    Thank you for the suggestion.

     

    It turns out, the query was missing the depth parameter (without it, instead of getting post date of the message itself, query returned post date of its latest replies too)

    • VikasB's avatar
      VikasB
      Boss
      7 years ago

      arthur_

      It seems there is some misunderstanding or it may be your instance-specific issue. Every message will return there own post time.  See here https://prnt.sc/iq7b9r

      If you want to get the only main topic then you have to pass the depth but it does not mean by passing the depth it returns the right time.

      select id, depth,post_time from messages where depth = 0 order by post_time desc
      • arthur_'s avatar
        arthur_
        Guide
        7 years ago

        VikasB

         

        Thank you very much for your support.

         

        I wasn't really aware on how depth works in relation to messages, but it's much clear right now.