ÇëÎÊÈçºÎ¸øMySQLÊý¾Ý¿â´«µÝDATETIMEÊý¾Ý£¿

ÇëÎÊÈçºÎ¸øMySQLÊý¾Ý¿â´«µÝDATETIMEÊý¾Ý£¿ÎÒÓõÄdate("Y-N-d H:i:s",time())²»ÐС£

---

SQL code:

mysql> desc t;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| dt | datetime | YES | | NULL | |
+-------+----------+------+-----+---------+-------+
1 row in set (0.03 sec)


PHP code:

mysql_query("insert into t values('".date("Y-m-d H:i:s",time())."')");


×¢ÒâÈÕÆÚÀàÐͲåÈëÊý¾Ý¿âÖÐÒªÓÃ''À¨Æð¡£

---

ISO±ê׼ʱ¼ä¸ñʽ
2009-01-01 01:01:01

---

µ¥ÒýºÅÒýÆðÁ˵ģ¬ÈÔÈ»¶Á³öÀ´ÊÇ0000-00-00 00:00:00

---

¹ûÈ»ºÃÓÃ