In Oracle/PLSQL, the systimestamp function returns the current system date and time (including fractional seconds and time zone) on your local database.
Syntax
The syntax for the systimestamp function is:
systimestamp
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i
For Example
select systimestamp
from dual;
The systimestamp function might return a value like this:
03-11-21 20:4
You can also choose to use the to_char function with the systimestamp function. For example:
select to_char(systimestamp, 'SSSS.FF')
from dual;
The function above may return a value such as:
4141.550774
Oracle/PLSQL的SYSTIMESTAMP函数用于获取本地数据库的当前系统日期和时间,包括秒的小数部分和时区信息。其语法简单,直接使用`systimestamp`即可。例如,查询语句`SELECT systimestamp FROM dual;`将返回当前时间。此外,可以结合`to_char`函数格式化显示时间,如`SELECT to_char(systimestamp, 'SSSS.FF') FROM dual;`,可能返回如`4141.550774`这样的结果。
925

被折叠的 条评论
为什么被折叠?



