summaryrefslogtreecommitdiff
path: root/contrib/spi/moddatetime.example
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/spi/moddatetime.example')
-rw-r--r--contrib/spi/moddatetime.example2
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/spi/moddatetime.example b/contrib/spi/moddatetime.example
index 25a54e3a335..e4a713c12a1 100644
--- a/contrib/spi/moddatetime.example
+++ b/contrib/spi/moddatetime.example
@@ -3,7 +3,7 @@ DROP TABLE mdt;
CREATE TABLE mdt (
id int4,
idesc text,
- moddate datetime DEFAULT datetime(CURRENT_TIMESTAMP) NOT NULL
+ moddate timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL
);
CREATE TRIGGER mdt_moddatetime