摘要：
CREATE OR REPLACE FUNCTION _time_to_integer(time with time zone)RETURNS integer AS $$ SELECT EXTRACT(HOUR FROM $1)::integer * 10000 + EXTRACT(MINUTE FROM $1)::integer * 100 + EXTRACT(SECONDS FROM $1)::integer$$ IMMUTABLE STRICT LANGUAGE SQL;DROP CAST IF EXISTS (time with time zone AS integ... 阅读全文
posted @ 2013-03-01 10:59 JasmineLiu 阅读(1905) 评论(0) 推荐(0) 编辑