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

CREATE OR REPLACE FUNCTION public.dayof(pg_catalog.date)
 RETURNS integer
 LANGUAGE sql
 STABLE NOT FENCED SHIPPABLE
AS $function$
    SELECT (EXTRACT(DOW from $1) + 1)::INTEGER
    $function$
;

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

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

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