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

"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'"

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  

this one work

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

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