Time stamp conversion

Unix timestamp conversion can turn Unix time into Beijing time, or turn Beijing time into Unix time.

current date： Current timestamp: Millisecond timestamp: Microsecond timestamp: Nanosecond timestamp:

Input timestamp: Conversion time:

Input time: Converted timestamp: millisecond: Microsecond: nanosecond:

Explain：

Supports second level timestamps, millisecond level timestamps, microsecond level, nanosecond level timestamps, which represent complete and verifiable data that existed before a specific time, usually a character sequence that uniquely identifies the time of a particular moment. The data generated using digital signature technology includes information such as original file information, signature parameters, and signature time. It is widely used in intellectual property protection, contract signing, financial accounting, electronic quotation bidding, stock trading, etc.

See how to access each language timestamp, please view it on the big screen!

language	Get timestamp
MYSQL	select *from `date` where DATEDIFF(FROM_UNIXTIME(unix_timestamp),NOW())=0 查询当前时间数据 unix_timestamp是时间戳 0是当天 -1是前一天
PHP	echo time();//秒时间戳
Java	(int) (System.currentTimeMillis() / 1000)
JavaScript	Math.round(new Date() / 1000)
Shell	date +%s
SQLite	SELECT strftime('%s', 'now')
Python	import time time.time()