GaussDB(DWS)迁移 - oracle兼容 -- weekof

CREATE OR REPLACE FUNCTION public.weekof(pg_catalog.timestamptz)
 RETURNS integer
 LANGUAGE sql
 STABLE NOT FENCED SHIPPABLE
AS $function$
    SELECT (EXTRACT(WEEK from $1) )::INTEGER
    $function$
;

CREATE OR REPLACE FUNCTION public.weekof(timestamp)
 RETURNS integer
 LANGUAGE sql
 STABLE NOT FENCED SHIPPABLE
AS $function$
    SELECT (EXTRACT(WEEK from $1) )::INTEGER
    $function$
;

CREATE OR REPLACE FUNCTION public.weekof(timestamptz)
 RETURNS integer
 LANGUAGE sql
 IMMUTABLE NOT FENCED SHIPPABLE
AS $function$
    SELECT (EXTRACT(WEEK from $1) )::INTEGER
    $function$
;

想了解GuassDB(DWS)更多信息，欢迎微信搜索“GaussDB DWS”关注微信公众号，和您分享最新最全的PB级数仓黑科技，后台还可获取众多学习资料哦~