Postgresql列出当月(或某几月）所有日期

有时候，我们需要构造一个自然天的列作为temp表来join其他表数据，列出当月(或某几月）所有日期：

select to_char(tt.day, 'yyyy-mm-dd') as dayfrom (select generate_series(cast(to_char(current_date, 'yyyy-mm') || '-01' as date),cast(cast(to_char(current_date, 'yyyy-mm') || '-01' as timestamp) + '1 MONTH' + '-1 d' asdate), '1 d') as day) as ttorder by day;select to_char(tt.day, 'yyyy-mm-dd') as orderDate
from (select generate_series(cast(to_char(to_date('2018-07-11', 'YYYY-MM'), 'yyyy-mm') || '-01' as date),cast(cast(to_char(to_date('2018-08-12', 'YYYY-MM'), 'yyyy-mm') || '-01' as timestamp) + '-1 d'as date), '1 d') as day) as tt
order by orderDate;

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！