sqlʱ¼ä¸üÐÂÎÊÌâ¡£ - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÎÒÔÚ²éѯ·ÖÎöÆ÷ÀÊäÈë
select DATEADD(s,1196660520,'1970-01-01 00:00:00')
Äܹ»²éѯ³öÕýÈ·µÄ½á¹û µ«ÊǾßÌåÉè¼Æµ½×Ö¶Îʱ ¾Í±¨´í£º
select DATEADD(s,regtime,'1970-01-01 00:00:00') from fs_me_users
·þÎñÆ÷: ÏûÏ¢ 8116£¬¼¶±ð 16£¬×´Ì¬ 1£¬ÐÐ 1
º¯Êý dateadd µÄ²ÎÊý 2 µÄÊý¾ÝÀàÐÍ nvarchar ÎÞЧ¡£
1196660520¾ÍÊÇ×Ö¶ÎregtimeµÄֵѽ Ôõô±¨´íѽ£¿
DATEADDµÚ2¸ö²ÎÊýÐèÒªÓþßÌåµÄÖµ ¶ø²»ÊÇ×Ö¶ÎÃû
SQL code:
DATEADD
ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ¡£
Óï·¨
DATEADD ( datepart , number, date )
²ÎÊý
datepart
Êǹ涨ӦÏòÈÕÆÚµÄÄÄÒ»²¿·Ö·µ»ØÐÂÖµµÄ²ÎÊý¡£Ï±íÁгöÁË Microsoft® SQL Server™ ʶ±ðµÄÈÕÆÚ²¿·ÖºÍËõд¡£
ÈÕÆÚ²¿·Ö Ëõд
Year yy, yyyy
quarter qq, q
Month mm, m
dayofyear dy, y
Day dd, d
Week wk, ww
Hour hh
minute mi, n
second ss, s
millisecond ms
number
ÊÇÓÃÀ´Ôö¼Ó datepart µÄÖµ¡£Èç¹ûÖ¸¶¨Ò»¸ö²»ÊÇÕûÊýµÄÖµ£¬Ôò½«·ÏÆú´ËÖµµÄСÊý²¿·Ö¡£ÀýÈ磬Èç¹ûΪ datepart Ö¸¶¨ day£¬Îª number Ö¸¶¨ 1.75£¬Ôò date ½«Ôö¼Ó 1¡£
date
ÊÇ·µ»Ø datetime »ò smalldatetime Öµ»òÈÕÆÚ¸ñʽ×Ö·û´®µÄ±í´ïʽ¡£ÓйØÖ¸¶¨ÈÕÆڵĸü¶àÐÅÏ¢£¬Çë²Î¼û datetime ºÍ smalldatetime¡£
Èç¹ûÄúÖ»Ö¸¶¨Äê·ÝµÄ×îºóÁ½Î»Êý×Ö£¬ÔòСÓÚ»òµÈÓÚ"Á½Î»ÊýÄê·Ý½ØÖ¹ÆÚ"ÅäÖÃÑ¡ÏîµÄÖµµÄ×îºóÁ½Î»Êý×ÖµÄÊý×ÖËùÔÚÊÀ¼ÍÓë½ØÖ¹ÄêËùÔÚÊÀ¼ÍÏàͬ¡£´óÓÚ¸ÃÑ¡ÏîµÄÖµµÄ×îºóÁ½Î»Êý×ÖµÄÊý×ÖËùÔÚÊÀ¼ÍΪ½ØÖ¹ÄêËùÔÚÊÀ¼ÍµÄÇ°Ò»¸öÊÀ¼Í¡£ÀýÈ磬Èç¹û
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......