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:
Ïà¹ØÎĵµ£º
sql server ʱ¼ä¶Î²éѯ¡£
==========================================
select g.borrowTime from t_apartment_goodsborrow g
where g.borrowTime >= '2010-03-11 9:50:43'
2010-03-11 9:52:54
----------------------------------------------------------------------------
select g.borrowTime ......
1.³£Á¿
¶¨ÒåÓï·¨¸ñʽ£º
³£Á¿Ãû constant ÀàÐͱêʶ·û [not null]:=Öµ;
È磺PI constant number(9):=3.1415;
2.»ù±¾Êý¾ÝÀàÐͱäÁ¿
»ù±¾Êý¾ÝÀàÐÍ
number Êý×ÖÐÍ
int ÕûÊýÐÍ
pls_integer ÕûÊýÐÍ£¬²úÉúÒç³öʱ³öÏÖ´íÎó
binary_integer ÕûÊýÐÍ£¬±íʾ´ø·ûºÅµÄÕûÊý
char ¶¨³¤×Ö·ûÐÍ£¬×î´ó255¸ö×Ö·û
varchar2 ±ä³¤× ......
µ¼ÈëµÄÏêϸÁ÷³Ì
1¡¢Ð½¨Ò»¸öÊý¾Ý¿â
2¡¢ÔÚеÄÊý¾Ý¿âÉϵãÓÒ¼ü-¡·“ËùÓÐÈÎÎñ”-¡·“µ¼ÈëÊý¾Ý¿â”£¬µãÏÂÒ»²½
3¡¢Ê²Ã´¶¼²»Òª¸Ä£¬ÔÚÊý¾Ý¿âÖÐÑ¡ÔñÄǸö¾ÉµÄÊý¾Ý¿â£¬µãÏÂÒ»²½
4¡¢ÔÚÕâ¸ö½çÃæµÄÊý¾Ý¿âÖÐÑ¡ÔñÄãн¨µÄÊý¾Ý¿â£¬µãÏÂÒ»²½
5¡¢Ñ¡Ôñ“ÔÚSQL SERVERÊý¾Ý¿âÖ®¼ä¸´ÖƶÔÏóºÍÊý¾Ý”£¬µãÏÂÒ»²½
......
Ò»¸ö¼òµ¥µÄСʵÀý¾ÍÃ÷°×~£¡
user±í
ÔÚÕâÕűíÖн¨Á¢´¥·¢Æ÷
Create trigger tiggername
on user
for delete
as
begin ......