Guest User

Untitled

a guest
Nov 18th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. select current_date - '2017-01-01',
  2. extract(day from now()::timestamp - '2017-01-01 00:00:00'),
  3. extract(day from now() - '2017-01-01 00:00:00Z');
  4.  
  5. select make_interval(days => ((extract(epoch from '2016-04-10'::date) - extract(epoch from '2016-02-10'::date))/(60*60*24))::integer)::text;
  6.  
  7. select format('%1$s days', ((extract(epoch from '2016-04-10'::date) - extract(epoch from '2016-02-10'::date))/(60*60*24))::integer);
Add Comment
Please, Sign In to add comment