pgsql 截取时间字段,输入性别等需要判断的字段

SELECT
u.name AS my_name, to_char(pr.create,‘YYYY-MM-dd’), (CASE
WHEN gender = ‘1’ THEN ‘男’
WHEN gender = ‘3’ THEN ‘女’
END ) AS gender,pr.age,pr.description,
uu.name AS consultant_name, m.value AS c_icon_url
FROM pmxl_reservation AS pr
INNER JOIN users AS u ON pr.user_id = u.id
INNER JOIN users AS uu ON pr.consultant_id = uu.id
INNER JOIN metas_mapping AS mm ON mm.object_id = uu.id
INNER JOIN metas AS m ON mm.meta_id = m.id
WHERE meta_type=‘header_img’ AND user_id = ‘" . $user_id . "’ AND pr.status != ‘1’

pr.create 是一个类型为timestamp的字段,精确到毫秒,我需要查出精确到日的时间即可,—to_char(pr.create,‘YYYY-MM-dd’),

性别在数据表里用1 3 代表 pgsql用(CASE
WHEN gender = ‘1’ THEN ‘男’
WHEN gender = ‘3’ THEN ‘女’
END ) 解决这个问题