得到的结果是这样select A."COUNTTIME",A."INNUM" AS "INNUM",A."OUTNUM" AS "OUTNUM",B."GATENAME",D."ORGNAME",B."ZONEIDIN" from "COUNT_INFO" as A,"MONITOR_POINT_INFO" as B,"ZONE_INFO" as C,"ORG_INFO" as D where (C."ZONEIN"='2' or C."ZONEIDOUT"='2') and B."ID"=A."GATEID" and ( (. 是后面的不显示呢还是直接没有了 我直接复制运行结果得到的是这样的结果~所以很奇怪 "select A."COUNTTIME",A."INNUM" AS "INNUM",A."OUTNUM" AS "OUTNUM",B."GATENAME",D."ORGNAME",B."ZONEIDIN" from "COUNT_INFO" as A,"MONITOR_POINT_INFO" as B,"ZONE_INFO" as C,"ORG_INFO" as D where (C."ZONEIN"='2' or C."ZONEIDOUT"='2') and B."ID"=A."GATEID" and ( (..)" 高人指点下,谢谢
提供类型之间的转换 看你的样子不知道是不是字符号转数字 CREATE OR REPLACE FUNCTION int4("char") RETURNS integer AS 'chartoi4' LANGUAGE 'internal' IMMUTABLE STRICT COST 1; ALTER FUNCTION int4("char") OWNER TO postgres; COMMENT ON FUNCTION int4("char") IS 'convert char to int4'; 还有int8的,类似
是后面的不显示呢还是直接没有了
我直接复制运行结果得到的是这样的结果~所以很奇怪
"select A."COUNTTIME",A."INNUM" AS "INNUM",A."OUTNUM" AS "OUTNUM",B."GATENAME",D."ORGNAME",B."ZONEIDIN" from "COUNT_INFO" as A,"MONITOR_POINT_INFO" as B,"ZONE_INFO" as C,"ORG_INFO" as D where (C."ZONEIN"='2' or C."ZONEIDOUT"='2') and B."ID"=A."GATEID" and ( (..)"
高人指点下,谢谢
convert(varchar(10),A."COUNTTIME",120)
postgresql 有这个函数吗?
看你的样子不知道是不是字符号转数字
CREATE OR REPLACE FUNCTION int4("char")
RETURNS integer AS
'chartoi4'
LANGUAGE 'internal' IMMUTABLE STRICT
COST 1;
ALTER FUNCTION int4("char") OWNER TO postgres;
COMMENT ON FUNCTION int4("char") IS 'convert char to int4';
还有int8的,类似