CURRENT_TIMESTAMP 以毫秒为单位

2022-01-13 00:00:00 postgresql datetime timestamp sql mysql

有没有办法从 MySql 或 PostgreSql (或其他只是出于好奇)中的时间戳中获取毫秒?

Is there any way to get milliseconds out of a timestamp in MySql or PostgreSql (or others just out of curiosity)?

SELECT CURRENT_TIMESTAMP --> 2012-03-08 20:12:06.032572

有没有这样的:

SELECT CURRENT_MILLISEC --> 1331255526000

或者唯一的选择是使用 era 中的 DATEDIFF?

or the only alternative is to use the DATEDIFF from the era?

推荐答案

在 MySQL 中获取 Unix 时间戳以秒为单位:

To get the Unix timestamp in seconds in MySQL:

select UNIX_TIMESTAMP();

详细信息:http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp

没有测试过 PostgreSQL，但是根据这个站点它应该可以工作:http://www.raditha.com/postgres/timestamp.php

Not tested PostgreSQL, but according to this site it should work: http://www.raditha.com/postgres/timestamp.php

select round( date_part( 'epoch', now() ) );

相关文章