Help Center/
GaussDB/
Developer Guide(Distributed_V2.0-8.x)/
FAQs/
How do I create a column whose default value is the current time?
Updated on 2025-08-19 GMT+08:00
How do I create a column whose default value is the current time?
Answer: When creating a table, set the default value of the column to CURRENT_TIMESTAMP.
Example:
gaussdb=# CREATE TABLE tbl (id int, modtime date DEFAULT CURRENT_TIMESTAMP);
Parent topic: FAQs
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
