Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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()£¬»¹Òª¿´ÏµÍ³µÄÊ±ÇøÉèÖá£



Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ