Greenplum实现年月日格式时间转时间戳函数-笔记
转时间戳函数create or eplace function data_to_timestamp(datestr timestamp)RETURNS BIGINT ASBODYBODYBODYDELCAREresult BIGINT;BEGINresult :=extract(epoch FROM date_trunc(‘MS’,to_timestamp(cast(datestr as varchar),‘YYYY-MM-DD HH24:MI:SS.MS’)))*1000;RETURN r
原创
2020-05-13 15:50:20 ·
2111 阅读 ·
0 评论