SCN_TO_TIMESTAMP

最新推荐文章于 2024-05-29 23:57:42 发布

amber112

最新推荐文章于 2024-05-29 23:57:42 发布

阅读量4.1k

点赞数

分类专栏： oracle 文章标签： function

oracle 专栏收录该内容

59 篇文章 0 订阅

订阅专栏

本文介绍了Oracle数据库中SCN_TO_TIMESTAMP函数的用途及使用方法。该函数能够将系统更改编号(SCN)转换为对应的近似时间戳。文章通过具体实例展示了如何结合ORA_ROWSCN伪列来获取某行最近更改的时间戳。

摘要由CSDN通过智能技术生成

SCN_TO_TIMESTAMP

Purpose

SCN_TO_TIMESTAMP takes as an argument a number that evaluates to a system
change number (SCN), and returns the approximate timestamp associated with that
SCN. The returned value is of TIMESTAMP datatype. This function is useful any time
you want to know the timestamp associated with an SCN. For example, it can be used
in conjunction with the ORA_ROWSCN pseudocolumn to associate a timestamp with the
most recent change to a row.

Examples

The following example uses the ORA_ROWSCN pseudocolumn to determine the system
change number of the last update to a row and uses SCN_TO_TIMESTAMP to convert
that SCN to a timestamp:
SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN) FROM employees
WHERE employee_id = 188;