Yuanj-11

EXTRACT(MONTH FROM T2.CREATE_TIME) AS MONTH

pgsql

what 's your version?

wait,I'll update it

no,still not return integer type.

here is it. CREATE TABLE t_wms_outstock_doc ( receive_doc character varying(50) null, finish_time timestamp without time zone null, doc_no character varying(50) null, doc_type character varying(50) null, dispatch_sn character varying(50) null, doc_status...

thankyou.

emm,so strange…

same as you. But when I export the data, it is an integer