请问这个sql语句怎么写?? select *from table where time between 3.12 and 4.12 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select *from table where time between #12-3-2004# and #12-4-2004# select * from table where time between ("1998-05-05" - INTERVAL 1 MONH) and "1998-05-05" 少写个字符select * from table where time between ("1998-05-05" - INTERVAL 1 MONTH) and "1998-05-05" 我想取当前日期,是不是改为select * from table where time between (date() - 30) and date()这样行吗?? select * from table where (to_days(now())-to_days(time))<30 select * frome tabalenamewhere itime>"yy-3-12"and itime<"yy-4-12" SELECT * FROM tableWHERE time BETWEEN (curdate( ) - INTERVAL 1 MONTH ) AND curdate( ) select * from table where (to_days(now())-to_days(字段))<30 把PHP作为脚本执行的问题! 如何用eAccelerator加密PHP文件? 学了点php基础,想更深入点该怎么学习呢 PDOException 的输出 新网站大家给点意见!!! php中是否可以这样输出<%=变量%> ? Discuz! 那个版本支持生成HTML session的问题? 分页显示问题,代码贴出来了,请高人帮忙啊! PHP的网络安全性怎么样???(23) 也面老是出现CGI错误,是不是PHP没有装好呀? 请问一个很急的关于显示数据的问题,我的分都没有了,以后给大家补上,谢谢~
select * from table where time between ("1998-05-05" - INTERVAL 1 MONTH) and "1998-05-05"
select * from table where time between (date() - 30) and date()这样行吗??
where itime>"yy-3-12"
and itime<"yy-4-12"
FROM table
WHERE time
BETWEEN (curdate( ) - INTERVAL 1 MONTH ) AND curdate( )