使用 FQL 设置日期格式
我正在尝试执行以下 Facebook 查询语言查询：
https://api.facebook.com/method/fql.query?query=SELECT name FROM user WHERE uid IN (SELECT actor_id FROM stream WHERE app_id = 131580206909839 AND xid = 'daily_thred_production' AND created_time > 2011-03-06 AND created_time < 2011-03-08)
问题是日期无法识别，并且我无法从 Facebook 开发人员部分找到任何有关如何格式化 FQL 日期的文档。有什么想法吗？
编辑 我是通过 URL 完成所有这些操作，无需任何编程语言。我只是想为一些同事获取一次性统计数据。
大纪元时间似乎有效，谢谢！唯一的问题是它只显示首次参与该流的新用户。不幸的是，我正在尝试找到流中的每个人，我必须更仔细地查看流表。
谢谢布莱恩。
I'm trying to do the following Facebook Query Language query:
https://api.facebook.com/method/fql.query?query=SELECT name FROM user WHERE uid IN (SELECT actor_id FROM stream WHERE app_id = 131580206909839 AND xid = 'daily_thred_production' AND created_time > 2011-03-06 AND created_time < 2011-03-08)
The problem is that the dates aren't being recognized and I can't find any documentation on how to format FQL dates from the Facebook developer section. Any thoughts?
EDIT
I'm doing all of this from the URL with no programming language. I'm just trying to pull one-off statistics for some co-workers.
Epoch time seems to work, thanks! Only problem is that it's only displaying new users that contributed to the stream for the first time. Unfortunately I'm trying to find everyone in the stream, I'll have to look at the stream table more carefully.
Thanks Brian.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
它们是纪元时间（自 UTC 1970 年 1 月 1 日 00:00:00 以来的秒数）
您需要以您使用的任何语言将日期转换为纪元时间。
编辑：如果您需要示例，请告诉我您正在使用的编程语言。
They're epoch time (Number of seconds since 00:00:00 Jan 1, 1970 UTC)
You need to convert your dates to epoch time in whatever language you're using.
EDIT: If you need an example, let me know what programming lang you're using.