将时间戳插入数据库，格式为：1311602030

Question

I am woandering how I can store time to my table in this format:

1311602030

Currently I am doing it this way:

INSERT INTO my_table (time) VALUES ( UTC_TIMESTAMP() )

which gives me back this:

2015-04-14 22:52:11

What I could do is:

INSERT INTO my_table ( time ) VALUES (  strtotime( UTC_TIMESTAMP() )  )

but isn't there a better way?

Answer 1

Assuming you are using MySQL, what you are looking for is UNIX_TIMESTAMP:

INSERT INTO my_table (time) VALUES ( UNIX_TIMESTAMP() )

More information here: https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp