Products
High-quality database products to meet full lifecycle enterprise data management needs.
Resources
Various types of resources about OceanBase and the database industry
Docs
Rich content to meet the content demands of using products and solving product usage problems
OceanBase Database
Download PDF
OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.
Resources
© OceanBase 2024. All rights reserved | Cloud Service Agreement | Privacy Policy | Legal | Security
OceanBase Database
SYSDATE(fsp)
SYSDATE() returns the current date and time in the %Y-%m-%d %H.%i.%s format.
The fsp argument specifies the precision of the return value, which means the number of digits of the fractional part. Valid values are any integers ranging from 0 to 6. The default value is 0.
obclient> SELECT SYSDATE();
+---------------------+
| SYSDATE() |
+---------------------+
| 2021-07-15 14:10:06 |
+---------------------+
1 row in set