<![CDATA[向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除]]> http://jackxiang.com/index.php zh-cn http://jackxiang.com/post// <![CDATA[[个人原创]Mysql取得时间后分天来查询日期的两种方法]]> jack <xdy108@126.com> Wed, 30 Dec 2009 03:36:24 +0000 http://jackxiang.com/post// [code]
$sql="select count(*) from Tbl_XXshow_XX where  FXX='$XX' and FCode=2 and left(FTime,7)=left(now(),7)";
select count(*) as c from Tbl_Exchange_XX where FLType=218 and date_format(now(),'%Y-%m-%d')=date_format(FTime,'%Y-%m-%d')
[/code] ]]> http://jackxiang.com/post//#blogcomment <![CDATA[[评论] [个人原创]Mysql取得时间后分天来查询日期的两种方法]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://jackxiang.com/post//#blogcomment