mysql datetimeµÄÎÊÌâ
ÎÒÔÚmysqlÊý¾Ý¿âÖÐÓÃdatetime×÷Ϊ×ֶεÄÀàÐÍ£¬²éѯµÄ½á¹û¼¯ÖУ¬¸Ã×ֶεÄÖµºóÃæ¶àÓàÁË.0 ÀýÈ磺 Êý¾Ý¿â´æ´¢µÄÊÇ2010-03-09 10:25:20 µ«ÊÇ´Ó½á¹û¼¯ÖÐÈ¡³öµÄÈ´ÊÇ2010-03-09 10:25:20.0 ÇëÎÊ´ó¼ÒÕâÊÇÔõôһ»ØÊÂÄØ£¿ÓÃʲô°ì·¨Äܽâ¾öÄØ£¬³ýÁË×Ö·û´®½ØÈ¡Ö®Íâ~~ ллà¶~
Java code: <%=new java.text.SimpleDateFormat("yyyy-MM-dd").format(rs.getTimestamp("rdate")%> Java code: <%=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(rs.getTimestamp("rdate")%> û·¢ÏÖÄã˵µÄÎÊÌ⣡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡ÒýÓà û·¢ÏÖÄã˵µÄÎÊÌ⣡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡ °¡¡£¡£¡£¡£¡£ ÎÒÓÃdatetimeÀàÐÍ£¬²éѯ´òÓ¡µÄʱºò¾Í¶à³öÁ˸ö.0 °¡ £¬ÕæÊÇÓôÃÆËÀÁË£¬¸É´àÖ±½Ó½ØµôµÃÁËÒýÓà Java code<%=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(rs.getTimestamp("rdate")%> ÄãµÄÕâÖнâ¾ö·½·¨¿ÉÒÔ£¬ ÎÒÊÇÏëÎÊÈçºÎ´ÓÊý¾Ý¿â±¾Éí½â¾ö£¬ ÊDz»ÊÇÊý¾Ý¿â·½ÃæµÄÎÊÌ⣬ ±¾À´ÊDz»Ó¦¸Ã³öÏÖÄÇÖÖÇé¿öµÄѾ ¶øÎÒÔÚ¿ØÖÆÌ¨Êä³ö´òÓ¡µÄʱºò È´³öÏÖà¶
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡ Íò·Ö¸Ðл£¡ String SQL=&q ......
ÔÚmysqlµÄ½Å±¾Ä£Ê½Ï£¬-t±íʾÒÔ±í¸ñµÄÐÎʽÊä³ö½á¹û£¬Èç¹ûÐèÒªÖÆ±í·û¶¨½çµÄÊä³ö¿ÉÒÔÊ¡ÂÔ´ËÑ¡Ïî¡£ ÕâÑùµÄÊä³öÊǾßÓбí¸ñÐÎʽµÄÊä³ö£¬ Õâ¸öÊÇÊéÉÏ˵µÄ£¬Õâ¾ä»°ÊDz»ÊÇÓÐʲôÎÊÌ⣿ ÊDz»ÊÇÖÆ±í·ûºÍ±í¸ñÐÎʽ£¬²»ÊÇÒ»»ØÊ ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬ Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ a ......