SQL 显示当天所有记录 语句

Question

SQl  显示当天所有记录显示当天所有记录  

Answer 1

试试这个：
select 
rq,
xm,
pm,
dj,
sf,
zz,
jz,
cz,
z1,
z2,
mz,
dj
 from [dbo].[p_hyd]
 WHERE  pm='玉米'
 and convert(varchar(10),rq,120) = convert(varchar(10),GETDATE(),120)
 

Answer 2

或者这样：select 
rq,
xm,
pm,
dj,
sf,
zz,
jz,
cz,
z1,
z2,
mz,
dj
 from [dbo].[p_hyd]
 WHERE  pm='玉米'
 and rq >=convert(varchar(10),GETDATE(),120)
 and rq < convert(varchar(10),dateadd(day,1,GETDATE()),120)
 

Answer 3

select 
rq,
xm,
pm,
dj,
sf,
zz,
jz,
cz,
z1,
z2,
mz,
dj
 from [dbo].[p_hyd]
 WHERE  pm='玉米'
and datediff(dd,getdate(),rq)=0

Answer 4

select rq,xm,pm,dj,sf,zz,jz,cz,z1,z2,mz,dj
 from dbo.p_hyd
 where pm='玉米' and datediff(d,rq,getdate())=0

Answer 5

假设你的rq是datetime类型的：SELECT  rq ,
        xm ,
        pm ,
        dj ,
        sf ,
        zz ,
        jz ,
        cz ,
        z1 ,
        z2 ,
        mz ,
        dj
FROM    [dbo].[p_hyd]
WHERE   pm = '玉米'
        AND rq > DATEADD(dd, -1, GETDATE())
        AND rq < DATEADD(dd, 1, GETDATE())

Answer 6

select rq,xm,pm,dj,sf,zz,jz,cz,z1,z2,mz,dj
 from dbo.p_hyd
 where pm='玉米' and datediff(d,rq,getdate())=0

Answer 7

rq 为datetime类型的话，可以
select rq,xm,pm,dj,sf,zz,jz,cz,z1,z2,mz,dj
 from dbo.p_hyd
 where pm='玉米' and rq>=datediff(d,0,getdate())=0

Answer 8

SQL Server的日期函数好多呢