deeejay icon

psql - Generate date series

deeejay | PRO | 02/27/14 06:20:50 PM UTC | 0 ⭐ | 319 👁️ | Never ⏰ | []
PostgreSQL |

70 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
select current_date + s.a as dates 
from generate_series(0,365,1) as s(a);

Comments