What Are The Units Used For last_publish_time
This Get messages posted or edited in a specified range of time (khoros.com) says n days, but the example here messages (khoros.com) is using numbers like 1577836860000. I thought maybe it was milliseconds but that doesn't seem to be the case. When I use 31540000000 which I believe is 365 days in milliseconds I am getting results from a board that did not exist a year ago. Anyone know what the units are or am I using this wrong? Thanks.
SELECT subject FROM messages WHERE board.id = "aktestboard" AND last_publish_time > 31540000000 LIMIT 1000
Those look like Epoch timestamps in milliseconds.
Try this converter to see if you can make sense of the numbers: https://www.epochconverter.com/
Using the example in messages that you sent, that range (in GMT) is:
1577836860000 -> Wednesday, January 1, 2020 12:01:00 AM
1596240060000 -> Saturday, August 1, 2020 12:01:00 AMIt doesn't seem likely that you'll be able to use this to specify a rolling X number of days, so your question still seems valid.
