Perl 6 - the future is here, just unevenly distributed

IRC log for #thinkup, 2013-10-09

| Channels | #thinkup index | Today | | Search | Google Search | Plain-Text | summary

All times shown according to UTC.

Time Nick Message
00:57 clreed87 joined #thinkup
08:30 GeordieNorman joined #thinkup
10:01 juser joined #thinkup
12:31 agsrv joined #thinkup
14:21 ScaredWee joined #thinkup
14:37 sjefen6 joined #thinkup
17:25 juser joined #thinkup
18:31 robbiet480 joined #thinkup
18:32 robbiet480 For some reason the API call for user_posts_in_range isn't working. I took a look at the query it's trying to run, and it's not outputting anything. Maybe variables aren't being replaced? I manually checked the DB and there is data in there with dates that would match
18:34 weems joined #thinkup
18:36 robbiet480 ah, i turned on the mysql query log, running the query produces no results and 3 warnings
18:36 robbiet480 SELECT p.*, pub_date + interval -7 hour as adj_pub_date FROM tu_posts p WHERE author_user_id = '46713' AND p.network='twitter' AND pub_date BETWEEN '31-12-2006' AND '31-1-2007' AND p.is_protected = 0 ORDER BY pub_date DESC
18:37 robbiet480 warnings all generated by Incorrect datetime value: '31-12-2006' for column 'pub_date' at row 1
18:37 robbiet480 >_>
18:39 robbiet480 okay so API docs are wrong, time needs to be given in either unix timestamp or YYYY-MM-DD HH:MM:SS
18:39 robbiet480 that was an easy fix
18:39 robbiet480 yup that fixed it
18:42 robbiet480 looks like unix timestamp isnt even natively supported because the column is datetime
18:42 robbiet480 anyway, fixed my issue, thanks :)
18:42 robbiet480 left #thinkup
19:19 agsrv joined #thinkup
22:40 moafak joined #thinkup

| Channels | #thinkup index | Today | | Search | Google Search | Plain-Text | summary