-- Create a table with a DATE column
CREATE TABLE events (
id SERIAL PRIMARY KEY,
event_name VARCHAR(255) NOT NULL,
event_date DATE NOT NULL
);
-- Insert data into the table
INSERT INTO events (event_name, event_date)
VALUES
('Launch Party', '2024-12-25'),
('Annual Meeting', '2025-01-10'),
('Product Release', '2025-03-15');
-- Query events happening in 2025
SELECT * FROM events WHERE event_date >= '2025-01-01' AND event_date < '2026-01-01';
-- Add an interval to a date
SELECT event_date + INTERVAL '7 days' AS reminder_date FROM events;