语名 说明 SELECT EXTRACT(YEAR FROM INTIME) FROM RK 从INTIME字段中提取年份 SELECT EXTRACT(MONTH FROM INTIME) FROM RK 从INTIME字段中提取月份 SELECT EXTRACT(DAY FROM INTIME) FROM RK 从INTIME字段中提取日 SELECT EXTRACT(HOUR FROM INTIME) FROM RK 从INTIME字段中提取时 SELECT EXTRACT(MINUTE FROM INTIME) FROM RK 从INTIME字段中提取分 SELECT EXTRACT(SECOND FROM INTIME) FROM RK 从INTIME字段中提取秒
CREATE TRIGGER "TRI_BI_AUTOID" FOR "TABLE1" ACTIVE BEFORE INSERT POSITION 0 AS
BEGIN NEW.PBID=CAST(EXTRACT(YEAR FROM CAST('NOW' AS DATE)) AS VARCHAR(4))|| CAST(EXTRACT(MONTH FROM CAST('NOW' AS DATE)) AS VARCHAR(2))|| CAST(EXTRACT(DAY FROM CAST('NOW' AS DATE)) AS VARCHAR(2))|| CAST(GEN_ID(AUTOID,1) AS VARCHAR(12)); END