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