SELECT to_char(tmp_date,
'YYYYMMDD') AS date_number,
to_char(tmp_date,
'YYYY-MM-DD') AS full_date
FROM (SELECT LEVEL n,
to_date('2012-12-30',
'YYYY-MM-DD') +
numtodsinterval(LEVEL,
'day') tmp_date
FROM dual
CONNECT BY LEVEL <= 400);
参考
阅读(2336) | 评论(0) | 转发(0) |