# bin and binr on dates

**URL:** <https://forum.kx.com/t/bin-and-binr-on-dates/9255>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [November 18, 2014, 1:19pm UTC](https://forum.kx.com/t/bin-and-binr-on-dates/9255 "2014-11-18T13:19:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vinson\_wangx](https://avatars.discourse-cdn.com/v4/letter/v/f08c70/32.png) [@vinson\_wangx](https://forum.kx.com/u/vinson_wangx)\
**Post date:** [November 18, 2014, 1:19pm UTC](https://forum.kx.com/t/bin-and-binr-on-dates/9255/1 "2014-11-18T13:19:00Z")

</div>

q)2013.01.01 2013.01.05 2013.01.10 bin 2013.01.06  
1  
q)2013.01.01 2013.01.05 2013.01.10 bin 2013.01.06 2013.01.03  
1 0  
q)2013.01.01 2013.01.05 2013.01.10 binr 2013.01.06  
2  
q)2013.01.01 2013.01.05 2013.01.10 binr 2013.01.06 2013.01.03  
2 1  
q)2013.01.01 2013.01.05 2013.01.10 binr 2013.01.06 2013.01.06&nbsp;&nbsp;&nbsp; / I am expecting 2 2, why 1 1??  
1 1  
q)2013.01.01 2013.01.05 2013.01.10 binr 2013.01.06 2013.01.06 2013.01.01  
2 2 0  
q)2013.01.01 2013.01.05 2013.01.10 bin 2013.01.06 2013.01.06  
1 1

---

<div class="post-metadata">

**Author:** ![charlie1](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@charlie1](https://forum.kx.com/u/charlie1)\
**Post date:** [November 18, 2014, 2:09pm UTC](https://forum.kx.com/t/bin-and-binr-on-dates/9255/2 "2014-11-18T14:09:00Z")

</div>

looks like a bug for binr with int vectors.  
workaround: cast both sides to longs.

q)(`long$2013.01.01 2013.01.05 2013.01.10) binr `long$2013.01.06 2013.01.06

2 2

---

<div class="post-metadata">

**Author:** ![charlie1](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@charlie1](https://forum.kx.com/u/charlie1)\
**Post date:** [November 18, 2014, 4:16pm UTC](https://forum.kx.com/t/bin-and-binr-on-dates/9255/3 "2014-11-18T16:16:00Z")

</div>

that’s fixed in kdb+3.2 2014.11.18

thanks for reporting it.

---

<div class="post-metadata">

**Author:** ![xun\_wang\_hz](https://avatars.discourse-cdn.com/v4/letter/x/f17d59/32.png) [@xun\_wang\_hz](https://forum.kx.com/u/xun_wang_hz)\
**Post date:** [November 19, 2014, 11:53am UTC](https://forum.kx.com/t/bin-and-binr-on-dates/9255/4 "2014-11-19T11:53:00Z")

</div>

thank you

---

<div class="post-metadata">

**Author:** ![vinson\_wangx](https://avatars.discourse-cdn.com/v4/letter/v/f08c70/32.png) [@vinson\_wangx](https://forum.kx.com/u/vinson_wangx)\
**Post date:** [November 23, 2014, 1:59am UTC](https://forum.kx.com/t/bin-and-binr-on-dates/9255/5 "2014-11-23T01:59:00Z")

</div>

The expressions in my first post are good on the new version,  
but something else looks wrong.

q)(`long$2013.01.01 2013.01.05 2013.01.10) binr `long$2013.01.05 2013.01.05  
1 1  
q)2013.01.01 2013.01.05 2013.01.10 binr 2013.01.05 2013.01.05  
2 2  
q).z.k  
2014.11.18

---

<div class="post-metadata">

**Author:** ![charlie1](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@charlie1](https://forum.kx.com/u/charlie1)\
**Post date:** [November 26, 2014, 9:53pm UTC](https://forum.kx.com/t/bin-and-binr-on-dates/9255/6 "2014-11-26T21:53:00Z")

</div>

thanks - fixed in kdb+3.2 2014.11.26