Advertisement
Guest User

Untitled

a guest
Sep 9th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION gentstz(seconds int) RETURNS timestamptz AS
  2. $$
  3. BEGIN
  4. RETURN '2016-05-24 17:00:00+00'::timestamptz + seconds * INTERVAL '1 second';
  5. END;
  6. $$
  7. LANGUAGE PLPGSQL IMMUTABLE;
  8.  
  9. /*
  10. test=# SELECT gentstz(72408438);
  11.         gentstz        
  12. ------------------------
  13.  2018-09-09 20:27:18+02
  14. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement