{dede:sql sql="SELECT * FROM dede_archives WHERE pubdate!=~pubdate~ and from_unixtime(pubdate,'%m') = month(from_unixtime(~pubdate~,'%Y-%m-%d')) and from_unixtime(pubdate,'%d') = day(from_unixtime(~pubdate~,'%Y-%m-%d'))"}
<li><a href="/read/[field:id/].html" title="[field:title/]" target="_blank"><span>[field:pubdate function="MyDate('Y',@me)"/]</span>[field:title/]</a></li>
{/dede:sql}
{dede:sql sql="SELECT * FROM dede_archives WHERE pubdate!=~pubdate~ and from_unixtime(pubdate,'%m') = month(from_unixtime(unix_timestamp(now()),'%Y-%m-%d')) and from_unixtime(pubdate,'%d') = day(from_unixtime(unix_timestamp(now()),'%Y-%m-%d'))"}
<li><a href="/read/[field:id/].html" title="[field:title/]" target="_blank"><span>[field:pubdate function="MyDate('Y',@me)"/]</span>[field:title/]</a></li>
{/dede:sql}
您可以选择一种方式赞助本站
赏