PostgreSQL 日付の計算／時間の計算

PostgreSQL

2024.02.19

SELECT current_date,current_timestamp,CURRENT_TIMESTAMP + INTERVAL '100 minutes';

SELECT current_date,current_timestamp,CURRENT_TIMESTAMP + INTERVAL '100 minutes';

SELECT current_date,current_timestamp,CURRENT_TIMESTAMP + INTERVAL '100 hours';

SELECT current_date,current_timestamp,CURRENT_TIMESTAMP + INTERVAL '100 hours';

select current_date,current_timestamp,current_timestamp+ cast( '100 days' as INTERVAL );

select current_date,current_timestamp,current_timestamp+ cast( '100 days' as INTERVAL );

SELECT CURRENT_TIMESTAMP + INTERVAL '100 years';

SELECT CURRENT_TIMESTAMP + INTERVAL '100 years';

タイトルとURLをコピーしました