如何在dob字段中分隔日期，月份，年份表格存储的数据库[关闭]

Question

"SELECT * FROM waiting EXTRACT(YEAR from dob) AS birthyear, EXTRACT(MONTH FROM dob) AS birthmonth, EXTRACT(DAY FROM dob) AS birthday WHERE mem_id='ADT56639'"

Answer 1

If you want more info then click On

SELECT  EXTRACT(YEAR FROM dob) AS birthyear,
EXTRACT(MONTH FROM dob) AS birthmonth,
EXTRACT(DAY FROM dob) AS birthday, waiting.* FROM 
waiting