deeejay

psql - Generate date series

Feb 27th, 2014
375
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select current_date + s.a as dates
  2. from generate_series(0,365,1) as s(a);
Advertisement
Add Comment
Please, Sign In to add comment