ããã«ã¡ã¯fukasawaã§ãããã¤ã¨ããã®ããã«ã¢ã³ã¯ã«ã¦ã§ã¤ããè³¼å ¥ããã®ã§ããã足é¦ã太ããã¦å·»ãã¾ããã§ãããç©ããã°ã ãã¦ãä»åã¯MySQLã®æ¥ä»æå»é¢æ°ã使ç¨ãã¦ãæ¥ä»ãæå»ã®å·®åãåå¾ããæ¹æ³ã«ã¤ãã¦ã§ããPERIOD_DIFF(),DATEDIFF(),TIMEDIFF(),TIMESTAMPDIFF()ã使ç¨ãã¦æ¥ä»ãæå»ã®å·®åãæ±ããæ¹æ³ã«ã¤ãã¦èª¿ã¹ã¦ã¿ã¾ããã â»MySQL 5.6.14ã§æ¤è¨¼ãã¦ãã¾ã DATEDIFF(expr,expr2) éå§æ¥ expr ã¨çµäºæ¥ expr2 ã¾ã§ã®æ¥æ°ãåå¾ãã¾ãã(v4.1.1以é) SELECT DATEDIFF('2013-12-31','2013-02-20'); -> 314 SELECT DATEDIFF('2013-12-31','2014-02-20'); -> -51 SELECT DATEDIFF('2
{{#tags}}- {{label}}
{{/tags}}