Skip to main content
replaced http://stackapps.com/ with https://stackapps.com/
Source Link

Date parameters are in unix epoch time and 1447113600 is 2015-11-10, 00:00:00. So any questions posted on Nov 10th actually happened after that.

When searching for date ranges, you usually want to increment the end-date (max in this case) by one full day.

For example, if you want items from 12-12-2012 to 12-13-2012, you would use max=1355443200 (The equivalent of 12 AM on 12-14-2012).

When you take this into account, then:

          /2.2/search/advanced?min=1446940800&max=1447200000&body=vm&tagged=sql-server

Returns the 3 questions you expect.

See this answerthis answer for more details.


PS: For your apparent task, you probably want sort=creation rather that sort=activity.

Date parameters are in unix epoch time and 1447113600 is 2015-11-10, 00:00:00. So any questions posted on Nov 10th actually happened after that.

When searching for date ranges, you usually want to increment the end-date (max in this case) by one full day.

For example, if you want items from 12-12-2012 to 12-13-2012, you would use max=1355443200 (The equivalent of 12 AM on 12-14-2012).

When you take this into account, then:

          /2.2/search/advanced?min=1446940800&max=1447200000&body=vm&tagged=sql-server

Returns the 3 questions you expect.

See this answer for more details.


PS: For your apparent task, you probably want sort=creation rather that sort=activity.

Date parameters are in unix epoch time and 1447113600 is 2015-11-10, 00:00:00. So any questions posted on Nov 10th actually happened after that.

When searching for date ranges, you usually want to increment the end-date (max in this case) by one full day.

For example, if you want items from 12-12-2012 to 12-13-2012, you would use max=1355443200 (The equivalent of 12 AM on 12-14-2012).

When you take this into account, then:

          /2.2/search/advanced?min=1446940800&max=1447200000&body=vm&tagged=sql-server

Returns the 3 questions you expect.

See this answer for more details.


PS: For your apparent task, you probably want sort=creation rather that sort=activity.

Source Link
Brock Adams
  • 13k
  • 5
  • 39
  • 64

Date parameters are in unix epoch time and 1447113600 is 2015-11-10, 00:00:00. So any questions posted on Nov 10th actually happened after that.

When searching for date ranges, you usually want to increment the end-date (max in this case) by one full day.

For example, if you want items from 12-12-2012 to 12-13-2012, you would use max=1355443200 (The equivalent of 12 AM on 12-14-2012).

When you take this into account, then:

          /2.2/search/advanced?min=1446940800&max=1447200000&body=vm&tagged=sql-server

Returns the 3 questions you expect.

See this answer for more details.


PS: For your apparent task, you probably want sort=creation rather that sort=activity.