[1] The number of digits to the right of the decimal point in a time or timestamp interval literal containing a seconds component is dependent on the seconds precision, as contained in the ...
ADD COLUMN IF NOT EXISTS created_at_pk TIMESTAMPTZ DEFAULT (NOW() AT TIME ZONE 'Asia/Karachi'); -- Add completed_at_pk (Pakistan time) column if it doesn't exist ALTER TABLE tasks ADD COLUMN IF NOT ...