Greenplum实现年月日格式时间转时间戳函数-笔记

转时间戳函数

create or eplace function data_to_timestamp(datestr timestamp)
RETURNS BIGINT AS
$BODY$
DELCARE
result BIGINT;
BEGIN
result :=extract(epoch FROM date_trunc(‘MS’,to_timestamp(cast(datestr as varchar),‘YYYY-MM-DD HH24:MI:SS.MS’)))*1000;
RETURN result;
END;
BODYBODY