Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE
- FUNCTION nsoft.tstamp_format(
- tstamp timestamptz,
- tzone text default 'utc',
- mask text default 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"'
- )
- RETURNS text
- LANGUAGE sql
- AS $function$
- select ret from (
- select
- set_config('timezone', tzone, true),
- to_char(tstamp, mask) ret
- ) t;
- $function$
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement