Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

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

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

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

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

iocpͬmysql´¦ÀíÊý¾Ý ¾ä±úÒ»Ö±Ôö¼Ó

iocpͬmysql´¦ÀíÊý¾Ý ¾ä±úÒ»Ö±Ôö¼Ó
·ÖÏí ³ÌÐòÔ±Ö®¼Ò£¨www.phome.asia£©¼¼Êõ¹Ù·½Èº£¬Ï£ÍûÓÐ־֮ʿµÄ¼ÓÈëŶ~~ºÙºÙ£¡
javaȺ£º
  javaÐÂÊÖȺ£º 19976477
  javaÐÂÊÖȺ2£º61983722
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ