mysql´¢´æʱ¼äÑ¡ÔñÔõÑùµÄ×Ö¶ÎÀàÐÍ
´¢´æʱ¼ä£¬³£ÓõÄÓÐÈý¸öÑ¡Ôñdatetime
¡¢timestamp
¡¢int
¡£×òҹͬÊÂÎʵ½ÁË£¬ÓÚÊǽñÌì¾Í×ܽáÒ»ÏÂ×Ô¼ºµÄÀí½â¡£
- ²åÈëЧÂÊ£ºdatetime > timestamp > int
- ¶ÁȡЧÂÊ£ºint > timestamp > datetime
- ´¢´æ¿Õ¼ä£ºdatetime > timestamp = int
½¨Á¢Ë÷ÒýµÄÌå»ý£¬ºÍË÷ÒýµÄËٶȣ¬Ä㶮µÄ¡£
ÈÃÎÒÃÇÀ´¿´Ò»¸öÓ¦Óó¡¾°£º
¿´ÏÂÕâÕÅͼ£¬µÚÒ»ÎÒÃÇÐèÒªÉèÖÃϵͳµÄĬÈÏʱÇø£¬µÚ¶þÎÒÃÇÒ²ÐèÒªÌṩ²»Í¬Ê±Çøʱ¼äÏÔʾµÄÐèÒª¡£ÓÚÊÇ£¬ÎÒÃÇ·Ö±ðʹÓÃdatetime
¡¢timestamp
¡¢int
×Ö¶ÎÀàÐÍÀ´¿´Ï£º
ʹÓÃdatetime
Ö±½ÓÏÔʾʱ¼ä£¬ÕâÊǸö²»´íµÄÑ¡Ôñ£¬µ«ÊÇÈç¹û¿¼Âǵ½Ê±Çø£¬ºÜÃ÷ÏÔ¼ÆËãÉϵÄÂé·³¡£
ʹÓÃtimestamp
OK,Õâ¸öºÜºÃ£¬¿ÉÒÔ¸ù¾ÝϵͳµÄʱÇøÀ´×Ô¶¯Êä³öʱ¼ä£¬µ«Êǵ¥¸öÓû§Òª¶¨ÖÆ×Ô¼ºµÄʱÇøÄØ£¿ÔÙÕßÄã²»ÅÂÂé·³£¬ÔÚ³ÌÐòÀïÃæʵÏÖÁËÕâ¸ö¼ÆË㣬·þÎñÆ÷ÈôÊÇ»»¸öµØ·½£¬¸ÄÁËÏÂʱÇø£¬Äã³ÌÐòÀïÃæ¼ÆËãµ¥¸öÓû§µ±µØʱ¼äµÄ´úÂëÔõô°ì£¨timestamp³öÀ´µÄʱ¼ä»á¸ù¾ÝʱÇøµÄ±ä»¯¶ø±ä»¯£¬ÔÚijЩÇé¿öÏÂÊDz»´íµÄÑ¡Ôñ£¬µ«ÔÚijЩÇé¿öÏ£¬ÕæµÄºÜ¼¦Àߣ©¡£
ʹÓÃint
´ÓÉÏÃæÁ½¸öÀàÐ͵Äȱµã¿´À´£¬Ã²ËÆÕâ¸öÀàÐÍ¿ÉÒÔ½â¾öÒÔÉϵÄÎÊÌ⣬ÆäʵÎÒÃÇÖ»Òª´æ¸ñÁÖʱ¼äµÄunix timestamp¾ÍºÃÁË£¬Ê±Çøʱ¼äµÄ¼ÆËãÉÏÒ²ºÜ·½±ã£¬¶ÁÈ¡µÄЧÂÊÒ²²»´í¡£ÎÒ¾õµÃÓÃÕâ¸ö´¢´æµÄȱµãÄØ£¬¾ÍÊÇÖ±½ÓselectµÄʱºòʱ¼ä²»ÄÜÖ±¹ÛµÄÏÔʾ³öÀ´¡£
¿´¿´ÆäËû¿ªÔ´³ÌÐòÊÇÔõô×öµÄ
discuz, typecho, emlogµÈµÈµÈµÈ£¬ËûÃǶ¼Ñ¡ÓÃintÁË£¬ÕâÒ»¶¨ÓÐËûÃǵĵÀÀí£¬ÎÒÏëҲûʲô¿ÉÒÔ¶à˵µÄÁË¡£
ÍƼöÐÅÏ¢
ÈÈÃÅÐÅÏ¢
- nohup: redirecting stderr to stdou....
- ʹÓÃlog_formatΪNginx·þÎñÆ÷ÉèÖøüÏêϸµÄÈÕÖ¾¸ñʽ
- jquery easyUI--dataGrid-Json
- [Ô´´]·ÂGoogle Reader¡¢ÐÂÀË΢²©¡¢ÌÚѶ΢²©µ....
- ÀûÓÃKeepalived+mysql¹¹½¨¸ß¿ÉÓÃMySQLË«Ö÷×Ô¶....
- Nginx+keepalivedʵÏÖ¸ºÔؾùºâºÍË«»úÈȱ¸¸ß¿ÉÓÃ
- jqueryʵÏÖÒ³Ãæ¼ÓÔؽø¶ÈÌõ
- Rolling cURL: PHP²¢·¢×î¼Ñʵ¼ù
- codeigniter ·ÓÉÖÕ¼«ÓÅ»¯(url rewrite)
- linuxÏÂÉèÖÃsshÎÞÃÜÂëµÇ¼
ÆÀÂÛ