Sql ²éѯµ±Ìì¡¢±¾ÖÜ¡¢±¾Ô¼Ç¼

Sql´úÂë:Powered by chenjiazi
--²éѯµ±Ì죺   
select * from info where DateDiff(dd,datetime,getdate())=0   
  
--²éѯ24СʱÄÚµÄ:   
select * from info where DateDiff(hh,datetime,getDate())<=24   
  
--infoΪ±íÃû,datetimeΪÊý¾Ý¿âÖеÄ×Ö¶ÎÖµ  
--²éѯµ±Ì죺select * from info where DateDiff(dd,datetime,getdate())=0--²éѯ24СʱÄÚµÄ:select * from info where DateDiff(hh,datetime,getDate())<=24--infoΪ±íÃû,datetimeΪÊý¾Ý¿âÖеÄ×Ö¶ÎÖµ
 
Sql´úÂë Powered by chenjiazi
 
--²éѯµ±Ìì¼Ç¼ÁíÀàµÄ·½·¨   
SELECT *   
from j_GradeShop   
WHERE (GAddTime BETWEEN CONVERT(datetime, LEFT(GETDATE(), 10) + ' 00:00:00.000')   
      AND CONVERT(datetime, LEFT(GETDATE(), 10) + ' 00:00:00.000') + 1)   
ORDER BY GAddTime DESC   
--²éѯµ±Ìì¼Ç¼ÁíÀàµÄ·½·¨SELECT *from j_GradeShopWHERE (GAddTime BETWEEN CONVERT(datetime, LEFT(GETDATE(), 10) + ' 00:00:00.000') AND CONVERT(datetime, LEFT(GETDATE(), 10) + ' 00:00:00.000') + 1)ORDER BY GAddTime DESC
DATEDIFF º¯Êý:
Óï·¨:
 
DATEDIFF ( datepart , startdate , enddate )
±¸×¢:
 
enddate ¼õÈ¥ startdate¡£Èç¹û startdate ÍíÓÚ enddate£¬Ôò·µ»Ø¸ºÖµ¡£
Èç¹û½á¹û³¬³öÕûÊýÖµ·¶Î§£¬Ôò DATEDIFF ½«²úÉú´íÎ󡣶ÔÓÚºÁÃ룬×î´óÊýÊÇ 24 Ìì 20 Сʱ 31 ·ÖÖÓÁã 23.647 Ãë¡£¶ÔÓÚÃ룬×î´óÊýÊÇ 68 Äê¡£
¿ç·ÖÖÓ¡¢ÃëºÍºÁÃëµÈ±ß½ç¼ÆËãµÄ·½·¨Ê¹µÃ DATEDIFF Ö¸¶¨µÄ½á¹ûÔÚËùÓÐÊý¾ÝÀàÐÍÖоùÒ»Ö¡£½á¹ûÊÇ´øÕý¸ººÅµÄÕûÊýÖµ£¬ËüµÈÓÚ¿çµÚÒ»¸öºÍµÚ¶þ¸öÈÕÆÚ¼äµÄ datepart ±ß½çÊý¡£ÀýÈ磬ÔÚ 1 Ô 4 ÈÕ£¨ÐÇÆÚÈÕ£©ºÍ 1 Ô 11 ÈÕ£¨ÐÇÆÚÈÕ£©Ö®¼äµÄÐÇÆÚÊýÊÇ 1¡£
¿ÉÒÔÔÙMSSQLÖвâÊÔ:
Sql´úÂë
 
--Á½¸öʱ¼ä²î¸ÕºÃÊÇ24   
--´òÓ¡µÄ·½Ê½   
print dateDiff(hh,'2009-1-1 0:0:0','2009-1-2 0:0:0')   
  
--²éѯµÄ·½Ê½   
print dateDiff(hh,'2009-1-1 0:0:0','2009-1-2 0:0:0')  
--Á½¸öʱ¼ä²î¸ÕºÃÊÇ24--´òÓ¡µÄ·½Ê½print dateDiff(hh,'2009-1-1 0:0:0','2009-1-2 0: