Create Unix timestamp in MySQL

Question

Create Unix timestamp in MySQL

How to create unix timestamp in MySQL? I know that the type matters INT

and the value NULL

, but I need to fill it with the current time in the format, for example: 1343782742

+3

sql mysql

BarclayVision 23 jan. 13 at 14:21

source to share

1 answer

John Woo · Answer 1 · 2013-01-23T14:22:54+0000

use UNIX_TIMESTAMP(date)

SELECT UNIX_TIMESTAMP(NOW())

Create Unix timestamp in MySQL

More articles: