Changeset 376


Ignore:
Timestamp:
2007/02/26 18:41:48 (17 years ago)
Author:
inoue
Message:

他のcastもdate_formatに統一

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/html/admin/home.php

    r374 r376  
    108108        $sql = "SELECT ".$method."(total) FROM dtb_order 
    109109                 WHERE del_flg = 0 AND date_format(create_date, '%Y/%m') = ?  
    110                  AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)"; 
     110                 AND date_format(create_date, '%Y/%m/%d') <> date_format(now(), '%Y/%m/%d')"; 
    111111    } 
    112112        $return = $conn->getOne($sql, array($month)); 
Note: See TracChangeset for help on using the changeset viewer.