´ø¡°ÔÖ¡±×ֵijÉÓÔÂÖµÄêÔÖ¡¹
±¾Ò³µ¼¶Á£º´ËÍøÒ³½éÉܳÉÓï¡°ÔÂÖµÄêÔÖ¡±µÄÍØÕ¹ÔĶÁ×ÊÁÏ£¬Ö÷ÒªÄÚÈݰüÀ¨³ÉÓïµÄ´ÊÌõ×ÊÁÏÒÔ¼°À©Õ¹×ÊÁÏ£ºexcelÖÐÈç¹û¼ÆËãÄêÔÂµÄÆ½¾ùÖµ£¿¡¢ÇëÎÊ Ê²Ã´ÊÇÄêÖµ ÔÂÖµ ÈÕÖµ ʱֵ£¿Ó¦¸ÃÈçºÎ²éѯ»òÍÆËãÄØ£¿Ð»Ð»¡¢excelÖÐÈç¹û¼ÆËãÄêÔÂµÄÆ½¾ùÖµ£¿¡¢sqlÔõôȡʱ¼ä×ֶεÄÄêÔÂÈÕµÄÖµ¡¢ÔÂÄê³ÉÓï·è¿ñ²Â³ÉÓï¡¢ÇëÎÊ´óʦ±¾ÈË´óÔËÄêÔºÍÄÄÄêÔ·ÝÔËÆø²»ºÃ£¬Ó¦¸Ã×¢Òâʲô£¿·Ç³£¸ÐлÄúµÄ»Ø´ð¡£¡¢mysql ÖÐÔõÑùȡһ¸öÈÕÆÚ×ֶεÄÄêÔ£¿±ÈÈçsignDate×ֶεÄֵΪ2013-12-19£¬ÎÒÖ»Òª2013-12£¬ÇóÒ»ÌõsqlÓï¾äµÈ
Ŀ¼Ë÷Òý£º
1£º³ÉÓï¡°ÔÂÖµÄêÔÖ¡±µÄ´ÊÌõ×ÊÁÏ
2£º±ð³æ³¦±ð±ôÖÐÈç¹û¼ÆËãÄêÔÂµÄÆ½¾ùÖµ£¿
3£ºÇëÎÊ Ê²Ã´ÊÇÄêÖµ ÔÂÖµ ÈÕÖµ ʱֵ£¿Ó¦¸ÃÈçºÎ²éѯ»òÍÆËãÄØ£¿Ð»Ð»
4£º±ð³æ³¦±ð±ôÖÐÈç¹û¼ÆËãÄêÔÂµÄÆ½¾ùÖµ£¿
5£º²õ±ç±ôÔõôȡʱ¼ä×ֶεÄÄêÔÂÈÕµÄÖµ
6£ºÔÂÄê³ÉÓï·è¿ñ²Â³ÉÓï
7£ºÇëÎÊ´óʦ±¾ÈË´óÔËÄêÔºÍÄÄÄêÔ·ÝÔËÆø²»ºÃ£¬Ó¦¸Ã×¢Òâʲô£¿·Ç³£¸ÐлÄúµÄ»Ø´ð¡£
8£ºmysql ÖÐÔõÑùȡһ¸öÈÕÆÚ×ֶεÄÄêÔ£¿±ÈÈçsignDate×ֶεÄֵΪ2013-12-19£¬ÎÒÖ»Òª2013-12£¬ÇóÒ»ÌõsqlÓï¾ä
³ÉÓï¡°ÔÂÖµÄêÔÖ¡±µÄ´ÊÌõ×ÊÁÏ
³ÉÓï¼òÆ´£ºYZNZ
³ÉÓï×¢Òô£º¨é¨Ý¨A ¨Ó¨@ ¨ËÒ»¨â¨@ ¨×¨Þ
³£Óó̶ȣºÉúƧ³ÉÓï
³ÉÓï×ÖÊý£ºËÄ×Ö³ÉÓï
¸ÐÇéÉ«²Ê£º±áÒå³ÉÓï
³ÉÓï½á¹¹£ºÁªºÏʽ³ÉÓï
³ÉÓïÄê´ú£º¹Å´ú³ÉÓï
³ÉÓï³ö´¦£ºÔª¡¤Î人³¼¡¶Óñºø´º¡·µÚÈýÕÛ£º¡°ÎÊÉõôײ×ÅÉ¥ÃÇ£¬¹ÜÉõô·ê×ŵõ¿Í£¬ÅÂÉõôÔÂÖµÄêÔÖ£¬Æ´ËÀÔÚݺ»¨Õ¯¡£¡± Ôª¡¤°×ÆÓ¡¶Ç½Í·ÂíÉÏ¡·µÚ¶þÕÛ£ºÔçÊDZ§ÏÐÔ¹•r¹ÔÔËå¿£¬ÓÖÌíÕ⺦Ïà˼ÔÂÖµÄêÔÖ¡£ ÄÚÈÝÀ´×Ôwww.gyjslw.com
³ÉÓï½âÊÍ£ºÎ½Ê±Ô˲»¼Ã¶øÔâÔÖ»ö¡£
³ÉÓïÓ÷¨£ºÔÂÖµÄêÔÖ×÷±öÓï¡¢¶¨ÓÓÃÓÚÊéÃæÓï¡£
³ÉÓïÔì¾ä£ºÁÏÓ¦ËûÒ¾øÂ»¾¡£¬Ê±¹ÔÔË×¾£¬ÔÂÖµÄêÔÖ¡£Ôª¡¤ÎÞÃûÊÏ¡¶Ð¡Î¾³Ù¡·µÚ¶þÕÛ
³ÉÓï¡°ÔÂÖµÄêÔÖ¡±µÄÀ©Õ¹×ÊÁÏ
1. excelÖÐÈç¹û¼ÆËãÄêÔÂµÄÆ½¾ùÖµ£¿excelÖÐÈçºÎ¼ÆËãÉϰàʱ¼äµÄƽ¾ùÖµµÄ·½·¨£º ´ò¿ªÒª±à¼µÄexcelµç×Ó±í¸ñ£» Ñ¡ÔñÒª¼ÆËãµÄƽ¾ùÖµµÄÊýÖµ £¬¿ÉÒÔÏÈÑ¡ÔñÒ»ÁлòÕßÒ»ÐУ¬ ÕâÀïÈ«²¿Ñ¡Ôñ£» µã»÷²Ëµ¥À¸ÀïµÄº¯Êý¼ÆËãͼ±ê£» µã»÷ÀïÃæµÄ¡°Ç󯽾ùÖµ¡±£» ²Ù×÷ÍêÒÔÉϲ½Ö裬¾Í¿ÉÒÔ¼ÆËã³öÏëÒªµÄƽ¾ùÖµ¡£
À´×ÔÂé¶¹ÊÓ´«Ã½¶ÌÊÓÆµ£º·É·É·É.²µ²âÂá²õ±ô·É.³¦´Ç³¾
2. ÇëÎÊ Ê²Ã´ÊÇÄêÖµ ÔÂÖµ ÈÕÖµ ʱֵ£¿Ó¦¸ÃÈçºÎ²éѯ»òÍÆËãÄØ£¿Ð»Ð»
Äê¡¢Ô¡¢ÈÕ¡¢Ê±Öµ¾ÍÊÇËüµÄ×îºóÒ»Ìì¡£
À´×Ô¹«Òæ³ÉÓ·É·É·É.²µ²âÂá²õ±ô·É.³¦´Ç³¾
3. excelÖÐÈç¹û¼ÆËãÄêÔÂµÄÆ½¾ùÖµ£¿
Ñ¡Öд¡µþÁÐÖ®ºó£¬°´¿ì½Ý¼ü£º´¡±ô³Ù+¶Ù+±Ê²¢Á¬Ðø°´3´Î·¡²Ô³Ù±ð°ù(»Ø³µ)£¬¾Í¿ÉÒÔÍê³ÉÊý¾Ý͸ÊÓ±íµÄ´´½¨¡£½«¡°ÈÕÆÚ¡±ÍÏÈëÏÂÃæµÄ¡°ÐС±½«¡°ÊýÁ¿¡±ÍÏÈëÏÂÃæµÄ¡°Öµ¡±ÔÚ¡°Öµ¡±µã»÷Êó±ê×ó¼ü£¬Ôڲ˵¥ÖÐÑ¡Ôñ¡°×Ö¶ÎÉèÖá±ÔÚµ¯³ö´°¿ÚÖУ¬µãÑ¡¡°Æ½¾ùÖµ¡±
Õª×Ô·É·É·É.²µ²âÂá²õ±ô·É.³¦´Ç³¾
4. sqlÔõôȡʱ¼ä×ֶεÄÄêÔÂÈÕµÄÖµ
select to_char(ʱ¼ä×Ö¶Î,¡¯yyyy-mm-dd¡¯) from ±íÃû;ÕâÑù¾ÍÈ¡³öʱ¼ä×Ö¶ÎÖеÄÄêÔÂÈÕ £¬¸ñʽΪ 2010-08-19
¹«Òæ³ÉÓ·É·É·É.²µ²âÂá²õ±ô·É.³¦´Ç³¾
5. ÔÂÄê³ÉÓï·è¿ñ²Â³ÉÓï
ÔÂÄê³ÉÓï £º
³¤ÄêÀÛÔ¡¢
»ýÄêÀÛÔ¡¢
ÄêÍ·ÔÂβ¡¢
ÄêÉîÔ¾á¢
ºïÄêÂíÔ¡¢
ÓÐÄêÎÞÔ¡¢
ÄêÔÖÔ»ޡ¢
ÄêÔÖÔ¶ò¡¢
Äê¸ÃÔÂÖµ¡¢
ÔÂÖµÄêÔÖ¡¢
·¼Ä껪ÔÂÂé¶¹ÊÓ´«Ã½¶ÌÊÓÆµ£º·É·É·É.²µ²âÂá²õ±ô·É.³¦´Ç³¾
6. ÇëÎÊ´óʦ±¾ÈË´óÔËÄêÔºÍÄÄÄêÔ·ÝÔËÆø²»ºÃ£¬Ó¦¸Ã×¢Òâʲô£¿·Ç³£¸ÐлÄúµÄ»Ø´ð¡£
ÐèÒª½áºÏÉú³½°Ë×ÖÀ´¿´¡£
ÄÚÈÝÀ´×ÔÂé¶¹ÊÓ´«Ã½¶ÌÊÓÆµ£º·É·É·É.²µ²âÂá²õ±ô·É.³¦´Ç³¾
7. mysql ÖÐÔõÑùȡһ¸öÈÕÆÚ×ֶεÄÄêÔ£¿±ÈÈçsignDate×ֶεÄֵΪ2013-12-19£¬ÎÒÖ»Òª2013-12£¬ÇóÒ»ÌõsqlÓï¾ä
mysqlÓÐÈÕÆÚº¯Êý date_formatSELECT date_format(signDate,¡¯%Y-%m¡¯) AS MY_YM FROM tablename WHERE 1;
Õª×Ô¹«Òæ³ÉÓ·É·É·É.²µ²âÂá²õ±ô·É.³¦´Ç³¾
°æÈ¨ÉùÃ÷£º±¾ÎÄÓÉÂé¶¹ÊÓ´«Ã½¶ÌÊÓÆµÊÕ¼¯ÕûÀí·¢²¼£¬ÈçÐè×ªÔØÇë×¢Ã÷³ö´¦¡£
±¾ÎÄÁ´½Ó£º/post/311660.html