SELECT COUNT (*) FROM VEH_DATA_ORDER WHERE TRUNC (GCSJ) = "TO_DATE" ('2016-11-21', 'yyyy-mm-dd');
以上是用trunc函数,数据库中是date类型。'yyyy-mm-dd'的大小写都可。
下面方法是to_char
SELECT count(*) FROM VEH_DATA_ORDER WHERE TO_CHAR(GCSJ,'YYYYMMDD') = '20161121'
Copyright @ 2024 booleen Powered by .NET 8.0 on Kubernetes Powered by: .Text and ASP.NET Theme by: .NET Monster