select year(fieldname),month(fieldname),day(fieldname) from tablename;
上面的语句有错。正确的如下: SELECT EXTRACT(year from now()),EXTRACT(month from now()),EXTRACT(day from now())
按照楼主的要求,应当是这样的: SELECT EXTRACT(year from table.field),EXTRACT(month from table.field),EXTRACT(day from table.field) from picture 注:table.field为此表某一时间型字体段。
select to_char(datefield,'yyyy'),to_char(datefield,'mm'),to_char(datefield,'dd') from table
from tablename;
SELECT EXTRACT(year from now()),EXTRACT(month from now()),EXTRACT(day from now())
SELECT EXTRACT(year from table.field),EXTRACT(month from table.field),EXTRACT(day from table.field) from picture
注:table.field为此表某一时间型字体段。