Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysqlʱ¼äת»»ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÎÒ°ÑsqlÀïµÄÊý¾Ýµ¼Èëµ½mysqlºó ·¢ÏÖphpwindÀïµÄʱ¼ä¶¼ÊÇ¡°1252466209¡± ÕâÖÖ¸ñʽµÄ ¶øÎÒµÄsqlÊý¾Ý¿âÀïµÄʱ
¼äÊÇÆÕͨ¸ñʽ£º11 15 2007 3:15PM ÕâÖÖ¸ñʽÔÚphpwindÒ³ÃæÉÏÊDz»ÄÜÕý³£ÏÔʾʱ¼äµÄ ÇëÎÊÎÒÓÃʲô·½·¨°ÑËüת»»³É
¡°252466209¡± ¸ñʽµÄÄØ£¿
ûʲô¹æÂɰ¢

DATE_FORMA T(date, format) ¸ù¾Ý¸ñʽ´®format ¸ñʽ»¯ÈÕÆÚ»òÈÕÆÚºÍʱ¼äÖµdate£¬·µ»Ø½á¹û´®¡£

2Â¥µÄÐÖµÜ ÎÒÓÃSELECT date_format(postdate,'%Y-%m-%d') as postdate from `pw_posts` ²»ÄÜ°Ñ 2010-3-10 15:07:00 ¸ñʽµÄת»¯Îª 1274249238 ¸ñʽµÄ ²éѯ³öÀ´µÄ¶¼ÊÇnull Ôõô°ìѽ£¿


1274249238ÕâÊÇʲô¸ñʽ°¡£¬Ê×ÏÈÄãÈ·¶¨ÄãµÄpostdate×Ö¶ÎÔÚmysqlÖÐÊÇdatetimeÀàÐÍ

¼û¹ýÒ»¸ö¶«Î÷ºÍÕâ¸öºÜÏñ£¬
ÒÔ1970Äê1ÔÂ1ÈÕΪÆðʼ£¬µÃ³öµÄsecondµÄ²î£¬ÎÒÃÇÔÚ8Çø£¬»¹Òª¼õµô8Сʱ
select dateadd(second,1252466209-28800,'1970-01-01')

Ôø¾­ÓÐÈËÓÃÕâ¸ö

ѧϰѧϰ

postdate×Ö¶ÎÔÚmysqlÖÐÊÇvarchar(100)Ð굀 ²»ÊÇdatetimeÀàÐÍ

SQL code:

--In SQL Server
SELECT DATEDIFF(second,'19700101',CONVERT(datetime,'11 15 2007 3:15PM',100))


ÕâÊÇÔÚCÓïÑÔ¿ª·¢»·¾³Öг£¼ûµÄÒ»ÖÖʱ¼ä±íʾ·½Ê½£¬1274249238±íʾ´Ó1970-1-1 00:00¿ªÊ¼ÖÁ½ñµÄÃëÊý¡£
ÖÁÓÚÊDz»ÊÇÒª¿¼ÂÇÖйú¶«8Çø£¬Òª¿´ÏàÓ¦µÄ¼ÆË㺯ÊýÊÇgmtime()»¹ÊÇlocaltime()£¬»¹Òª¿´ÏµÍ³µÄÊ±ÇøÉèÖá£



Ïà¹ØÎÊ´ð£º

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......

mysqlÍâ¼ü - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb

貼³öSQL&# ......

sqlÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ