如果在php代码当中比较就用楼上的 在mysql当中 select unix_timestamp(now())-unix_timestamp(字段) 在mssql当中 select case when datediff(second,字段,getdate())>0 then 'true' else 'false' end as flag
在mysql当中 select case when unix_timestamp(now())-unix_timestamp(字段)>0 then 'true' else 'false' end as flag
return true;
else
return false;
http://cn.php.net/manual/zh/function.strtotime.php
在mysql当中
select unix_timestamp(now())-unix_timestamp(字段)
在mssql当中
select case when datediff(second,字段,getdate())>0 then 'true' else 'false' end as flag
select case when unix_timestamp(now())-unix_timestamp(字段)>0 then 'true' else 'false' end as flag