Advertisement
Guest User

Untitled

a guest
Nov 7th, 2017
251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. CREATE OR REPLACE
  2. FUNCTION nsoft.tstamp_format(
  3. tstamp timestamptz,
  4. tzone text default 'utc',
  5. mask text default 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"'
  6. )
  7. RETURNS text
  8. LANGUAGE sql
  9. AS $function$
  10.  
  11. select ret from (
  12. select
  13. set_config('timezone', tzone, true),
  14. to_char(tstamp, mask) ret
  15. ) t;
  16. $function$
  17. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement