oracle中CURRENT_TIMESTAMP和SYSDATE不同

2021-12-05 00:00:00 sql oracle oracle10g plsql

在 oracle 10g 中执行此 SQL 后:

After executing this SQL in oracle 10g:

SELECT SYSDATE, CURRENT_TIMESTAMP  FROM DUAL

我收到这个奇怪的输出:

I receive this strange output:

时间差的原因是什么?服务器时间等于 SYSDATE 值

What is cause of the difference in time? The server time is equal of SYSDATE value

推荐答案

CURRENT_DATECURRENT_TIMESTAMP 返回会话时区中的当前日期和时间.

CURRENT_DATE and CURRENT_TIMESTAMP return the current date and time in the session time zone.

SYSDATESYSTIMESTAMP 返回系统日期和时间 - 即数据库所在的系统.

SYSDATE and SYSTIMESTAMP return the system date and time - that is, of the system on which the database resides.

如果您的客户端会话与数据库所在的服务器不在同一个时区(或者说它不是,通过您的 NLS 设置),混合 SYS*CURRENT_* 函数将返回不同的值.他们都是对的,他们只是代表不同的东西.看起来您的服务器处于(或认为是)+4:00 时区,而您的客户端会话处于 +4:30 时区.

If your client session isn't in the same timezone as the server the database is on (or says it isn't anyway, via your NLS settings), mixing the SYS* and CURRENT_* functions will return different values. They are all correct, they just represent different things. It looks like your server is (or thinks it is) in a +4:00 timezone, while your client session is in a +4:30 timezone.

如果时钟不同步,您可能还会看到时间上的微小差异,这在这里似乎不是问题.

You might also see small differences in the time if the clocks aren't synchronised, which doesn't seem to be an issue here.

相关文章