Skip to content

Instantly share code, notes, and snippets.

@yassine-khachlek

yassine-khachlek/PostgreSQL_timestamp_type_precision_limit.txt

Last active January 22, 2023 20:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yassine-khachlek/4ff743eaa992f361e187389273944e97 to your computer and use it in GitHub Desktop.
Save yassine-khachlek/4ff743eaa992f361e187389273944e97 to your computer and use it in GitHub Desktop.
Download ZIP
CREATE TABLE mytable (id SERIAL PRIMARY KEY, created_at TIMESTAMP(9) WITH TIME ZONE NOT NULL DEFAULT NOW());
Raw
PostgreSQL_timestamp_type_precision_limit.txt
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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment