CURRENT_TIMESTAMP and LOCALTIMESTAMP follow the above convention where the former returns TIMESTAMPTZ and latter returns TIMESTAMP.

However since we don't support TIME with time zone we cannot make that distinction in the case of CURRENT_TIME vs LOCALTIME