我有以下表格:
CREATE TABLE public.employees
(
employee_id integer NOT NULL,
name text NOT NULL,
date_of_birth date,
address text,
email text,
CONSTRAINT employees_pkey PRIMARY KEY (employees_id),
CONSTRAINT employees_email_key UNIQUE (email)
)
我怎样才能够将每个雇员的姓名和年龄列在输出中?谢谢。
age()
函数的文档在这里:https://www.postgresql.org/docs/current/static/functions-datetime.html - user330315