sql查詢某個(gè)時(shí)間段的數(shù)據(jù) sql怎樣查詢當(dāng)前系統(tǒng)時(shí)間是否大于某天?
sql怎樣查詢當(dāng)前系統(tǒng)時(shí)間是否大于某天?SQL Server declare@return as intif(select convert(varchar(100),getdate(),120))&g
sql怎樣查詢當(dāng)前系統(tǒng)時(shí)間是否大于某天?
SQL Server declare@return as intif(select convert(varchar(100),getdate(),120))> “2011-9-10 15:38:26”set@return=1else set@return=2select@return,然后只需獲取變量值即可