Yassine Khachlek yassine-khachlek

yassine-khachlek / PostgreSQL_timestamp_type_precision_limit.txt

Last active January 22, 2023 20:09

CREATE TABLE mytable (id SERIAL PRIMARY KEY, created_at TIMESTAMP(9) WITH TIME ZONE NOT NULL DEFAULT NOW());

	WARNING: TIMESTAMP(9) WITH TIME ZONE precision reduced to maximum allowed, 6
	LINE 3: created_at TIMESTAMP(9) WITH TIME ZONE NOT NULL DEFAULT ...
	^
	WARNING: TIMESTAMP(9) WITH TIME ZONE precision reduced to maximum allowed, 6
	CREATE TABLE

	Query returned successfully in 42 msec.