{"description":"mysql\u3067\u30de\u30a4\u30af\u30ed\u79d2\u307e\u3067\u8a08\u7b97\u3057\u3066\u304f\u308c\u308b\u306e\u306f\u5b09\u3057\u3044\u306e\u3067\u3059\u304c\u3001\u4fdd\u5b58\u3055\u308c\u308b\u3068\u304d\u306b\u306f\u5207\u308a\u6368\u3066\u306b\u3055\u308c\u3066\u3044\u307e\u3059\u3002 Rails\u306eend_of_day\u3092\u4f7f\u3046\u3068\u3001.9999\u306b\u306a\u308a\u307e\u3059\u3002 where('start_at <= ? and end_at >= ?', date.beginning_of_day, date.end_of_day) SELECT `xxxx`.* FROM `campaigns` WHERE (start_at <= '2019-09-28 15:00:00' and end_at >= '2019-09-29 14:59:59.999999') LIMIT 11 \u30ae\u30ea\u30ae\u30ea\u307e\u3067\u305d\u308c\u3092\u2026","title":"Rails\u306eActive Record\u306emysql\u3067\u30de\u30a4\u30af\u30ed\u79d2\u3092\u5207\u308a\u6368\u3066\u308b\u65b9\u6cd5","categories":["rails"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmikamisan.hatenablog.com%2Fentry%2F2019%2F09%2F30%2F000628\" title=\"Rails\u306eActive Record\u306emysql\u3067\u30de\u30a4\u30af\u30ed\u79d2\u3092\u5207\u308a\u6368\u3066\u308b\u65b9\u6cd5 - mikami&#39;s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://mikamisan.hatenablog.com/entry/2019/09/30/000628","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/frozen_faithjp/","author_name":"frozen_faithjp","blog_url":"https://mikamisan.hatenablog.com/","blog_title":"mikami's blog","height":"190","version":"1.0","image_url":null,"provider_url":"https://hatena.blog","width":"100%","type":"rich","published":"2019-09-30 00:06:28"}