MySQLã§DATETIMEåž‹ã®æ™‚刻差を計算 - 地ä¸ã¸ã®ã¯ã—ã”MySQL上ã§ã€DATETIMEåž‹ã®æ™‚間差を出ã™æ–¹æ³•ã§ã™ã€‚ 僕ã®å ´åˆã€å‡ºã—ãŸå€¤ã‚’åˆè¨ˆã—ã¦ã€ãã®å¾ŒPHPã§æ‰±ã†æµã‚Œã§ã—ãŸã®ã§ã€UNIX_TIMESTAMPã§å¤‰æ›ã—ã¦ã‹ã‚‰å·®ã‚’出ã™æ–¹æ³•ã‚’採用ã—ã¾ã—ãŸã€‚ 複数ã®æ–¹æ³•ã§çµæžœã‚’出ã—ã¦ã¿ã‚‹ å·¦2ã¤ã®ãƒ‡ãƒ¼ã‚¿ã®å·®åˆ†ã‚’ã€ã‚«ãƒ©ãƒ åã®æ–¹æ³•ã§å‡ºã—ã¦ã„ã¾ã™ã€‚ ãã®ã¾ã¾æ¸›ç®— æ•°å—列ã®å·®åˆ†ã«ãªã‚Šã¾ã™ã€‚ SELECT datetime1 - datetime2 FROM table_name UNIXTIMESTAMP化ã—ã¦ã‹ã‚‰è¨ˆç®— 秒数ã§å–å¾—ã§ãã¾ã™ã€‚ SELECT UNIX_TIMESTAMP( datetime1 ) - UNIX_TIMESTAMP( datetime2 ) FROM table_name SUBTIME()ã§è¨ˆç®— 後ã‚ã®å¼•æ•°ã¯æ™‚刻ã§ã¯ãªã時間を表ã™å€¤ã§ãªã‘ã‚Œã°ãªã‚‰ãªã„よã†ã§ã™ã€‚ SELECT SUBTIME(datetime1,datetime2)
{{#tags}}- {{label}}
{{/tags}}