目次 †
内容 †
Case文 †
日付 †
- 書式変換にはto_dateを利用
select
to_date( time, 'YYYY-mm' ) as month, count(1)
from fact_sales
group by month
order by month;
- x日後を表示
SELECT CAST( '2008-04-25' AS DATE ) + CAST( '7 days' AS INTERVAL );
- x日後に更新
update fact_sales set time = CAST( time as date ) - CAST( '1 years' as interval );
|