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

¶ÁÈ¡mysqlÊý¾ÝµÄÎÊÌâ

mysqlÀïÓÐÒ»ÕűíµÄÒ»¸öÈÕÆÚ×Ö¶Îdate£¬µ«ÊÇÓõÄint¡£
ÎÒÓÃÈçÏÂsqlÓï¾ä¶Á³öÀ´Ìî³äµ½datasetÀÎÒÒª°ÑÕâ¸öֵת»»³ÉdatetimeÀàÐÍ£¬µ«ÊÇʧ°Ü¡£SQL code:

select from_UNIXTIME(date)
from table1
C# code:

//ÏÈÌî³äDataSet ds
DateTime dt = Convert.ToDateTime(ds.Tables[0].Rows[0]["date"]);

³ÌÐò±¨´í£ºÎÞ·¨½«ÀàÐÍΪ¡°System.Byte[]¡±µÄ¶ÔÏóÇ¿ÖÆ×ª»»ÎªÀàÐÍ¡°System.IConvertible¡±¡£
´Ó¿âÖжÁ³öÀ´µÄ¶«Î÷ÒªÏÔʾת»»Ò»ÏÂÀàÐÍÔÙʹÓÃ

¸ñʽÎÊÌâ
¿´¿´ds.Tables[0].Rows[0]["date"]Êý¾Ý

C# code:
DateTime dt = Convert.ToDateTime(ds.Tables[0].Rows[0]["date"].ToString());


ÒªtostringÔÙת»»Îªdatetime

Ö÷ÒªÊÇ¿´Êý¾ÝµÄ¸ñʽ
ÄãÄܲ»Äܷż¸¸öÊý¾Ý³öÀ´¿´¿´Ñ½?
2009101?
20091001??


ѧϰһÏÂ

........

²Î¿¼£º
http://school.itzcn.com/special-spid-51.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£

ÒýÓÃ
¸ñʽÎÊÌâ
¿´¿´ds.Tables[0].Rows[0]["date"]Êý¾Ý
object£¬byte[19] ±ÈÈç2010-02-07 10:20:00

ÒýÓÃ
C# codeDateTime dt= Convert.ToDateTi


Ïà¹ØÎÊ´ð£º

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

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysqlÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......

ÎÊÒ»¸ö×Ö·û¼¯µÄÎÊÌ⣬´Ómysql°æÀ´

Ô­ÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......

mysql Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ 
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ