ATEåªæ¾ç¤ºæ¥æï¼æ²¡ææ¶é´é¨åãMySQLæ£ç´¢å¹¶ä¸ä»¥'YYYY-MM-DD'æ ¼å¼æ¾ç¤ºDATEå¼ï¼æ¯æçèå´æ¯ '1000-01-01'å°'9999-12-31'ã
DATETIMEæ¯æ¥æåæ¶é´çç»åãMySQLæ£ç´¢å¹¶ä¸ä»¥'YYYY-MM-DD
HH:MM:SS'æ ¼å¼æ¾ç¤ºDATETIMEå¼ï¼ä½å
许使ç¨å符串ææ°å为DATETIMEååé
å¼ãæ¯æçèå´æ¯'1000-01-01
00:00:00'å°'9999-12-31 23:59:59'
TIMEæ°æ®ç±»å表示ä¸å¤©ä¸çæ¶é´ãMySQLæ£ç´¢ 并ä¸ä»¥"HH:MM:SS"æ ¼å¼æ¾ç¤ºTIMEå¼ï¼ä½å
许使ç¨å符串ææ°å为TIMEååé
å¼ãæ¯æèå´æ¯'00:00:00'å°'23:59:59'ã
TIMESTAMP[(M)]
æ¶é´æ³ãèå´æ¯â1970-01-01 00:00:00âå°2037å¹´ãTIMESTAMPåç¨äºINSERTæUPDATEæä½æ¶è®°å½æ¥æåæ¶é´ã
å¦æä¸åé
ä¸ä¸ªå¼ï¼è¡¨ä¸ç第ä¸ä¸ªTIMESTAMPåèªå¨è®¾ç½®ä¸ºæè¿æä½çæ¥æåæ¶é´ãä¹å¯ä»¥éè¿åé
ä¸ä¸ªNULLå¼ï¼å°TIMESTAMPå设置为å½åçæ¥æåæ¶é´ã
TIMESTAMPå¼è¿ååæ¾ç¤ºä¸ºâYYYY-MM-DD HH:MM:SSâæ ¼å¼çå符串ï¼
æ¾ç¤ºå®½åº¦åºå®ä¸º19个å符ãå¦ææ³è¦è·å¾æ°åå¼ï¼åºå¨TIMESTAMP åæ·»å +0ã
温馨提示:答案为网友推荐,仅供参考