Tag: UNIX_TIMESTAMP

How do you convert between Unix timestamps and MySQL timestamps?

UNIX_TIMESTAMP converts from MySQL timestamp to Unix timestamp, FROM_UNIXTIME converts from Unix timestamp to MySQL timestamp.

How can we convert between Unix & MySQL time stamps?

UNIX_TIMESTAMP is the command which converts from MySQL time stamp to Unix time stamp

FROM_UNIXTIME is the command which converts from Unix time stamp to MySQL time stamp.