PDA

View Full Version : how to insert machine (local) time in mysql (see graph)


kendeji
04-25-2003, 09:28 AM
This is a problem I encountered in mysql: how do I insert local (machine) time?

To do this in MS Access, just put now(). I tried this in mysql, it does not work.

see graph(the red chinese characters means the same thing as above.)

Dylan Leblanc
04-25-2003, 12:29 PM
UPDATE table SET timeCreated = UNIX_TIMESTAMP() WHERE 1;