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()£¬»¹Òª¿´ÏµÍ³µÄʱÇøÉèÖá£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëÄ¿Ç°×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......